Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Scripts with tag Transaction Logs Rss

Search for any content tagged transaction logs

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 5 of 5   

Avoid Transaction Logs volume from filling

Script for preventing the volumes of the transaction logs from filling.  Read more...
By Daniel Marques 2014/07/02 | Source: | Category: transaction logs
Rating: |  Discuss |   Briefcase | 2,389 reads


Here is a short code to count the VLFs in the transaction log for each database in the instance.  Read more...
By Patrick Akhamie 2014/05/06 | Source: | Category: transaction logs
Rating: |  Discuss |   Briefcase | 1,042 reads

Right or Wrong, Dynamic SQL AND a Cursor

I'm no big fan of dynamic SQL or cursors, however there are times where they do the job.   Read more...
By Kurt Zimmerman 2013/11/08 | Category: transaction logs
Rating: |  Discuss |   Briefcase | 1,764 reads

Last Backup Taken, or Not

Displays the last Full, Diff, and Log backup taken. If no backup has been taken that is displayed as well.  Read more...
By Jon Morisi 2012/05/24 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 1,431 reads

Backup Both Full and TLog Database Backup within a single Job

This script is basically used in SQL Server 2005/2008 as that version not having the option to perform the same activity in the single window.  Read more...
By Nitin Gupta 2009/08/11 | Source: | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,592 reads
   Items 1 to 5 of 5