X hits on this document

627 views

0 shares

0 downloads

0 comments

182 / 200

182

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:

NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.db.pubs.~.7.001of001.20060628123631..C"

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

Document info
Document views627
Page views627
Page last viewedWed Jan 18 22:40:57 UTC 2017
Pages200
Paragraphs4189
Words49499

Comments