Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
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,127 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,652 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,441 reads
Items 1 to 3 of 3
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.