X hits on this document

491 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 views491
Page views491
Page last viewedWed Dec 07 16:50:13 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments