Sample batch files Sample 2 - Simple script to restore a database named pubs
Sample 2 - Simple script to restore a database named pubs
This sample restores database pubs based upon the backup:
You can find out which backups are available for restore by looking at the dbclient log file created when you did the backup or by using bplist. Refer to “Using bplist to retrieve SQL Server backups” on page 117.
OPERATION RESTORE OBJECTTYPE DATABASE DATABASE "pubs"
The following image is type: Full
NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.db.pubs.~.7.001of001.20060628123631..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "CHISEL" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE RECOVERED ENDOPER TRUE