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

Scripts by Smitha Reddy

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Restore database from a device containing multiple backups

Script to restore the LATEST full and differential backups from a SQL Server 2008 R2 backup device.  Read more...
By Smitha Reddy 2012/01/04 | Source: SQLServerCentral.com | Category: restore database
Rating: |  Discuss |   Briefcase | 1,372 reads

SQL Agent Jobs Summary

The following script can be used to determine the list of enabled SQL Agent Jobs, their start time, average run duration and next run date.  Read more...
By Smitha Reddy 2011/12/29 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,800 reads

Using sys.dm_exec_requests to estimate completion time for a process

The following script is used to check on the progress of a database restore, backup and other processes currently executing on SQL Server.  Read more...
By Smitha Reddy 2011/10/05 | Source: SQLServerCentral.com | Category: sys.dm_exec_requests
Rating: |  Discuss |   Briefcase | 1,550 reads
   Items 1 to 3 of 3