SQL Clone
SQLServerCentral is supported by Redgate
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
Rating: |  Discuss |   Briefcase | 1,825 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 | 2,031 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,720 reads
   Items 1 to 3 of 3