Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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)

Yet another restore script usp_restore

By Wesley Brown,

usp_restore - This will restore a backup performed with SQL LiteSpeed from DBAssocatesIT or by the standard backup database routines in SQL Server Please check below the declarations to find the user settable options for this script If the target database is currently in a loading status or cannot be read from this restore it will fail. It requires the ability to read from the sysfiles table to do the WITH MOVE clause in the backup statement. Update to fix a couple of bugs.

Total article views: 601 | Views in the last 30 days: 1
 
Related Articles
FORUM

Backup/restore

Backup/restore

FORUM

Backup restore

Backup And Restore

FORUM

Backup & restore

Need assist for backup & restore

FORUM

Restoring Backup -Size Issue

Restoring Backup- Size Issue

FORUM

backup and Restore

backup and Restore

 
Contribute