This example shows a script for a full database restore that you generate in the Restore Microsoft SQL Server Objects dialog box.
OPERATION RESTORE OBJECTTYPE FILEGROUP DATABASE "DatabaseR" OBJECTNAME "PRIMARY" # The following image is type: Filegroup NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.fg.DatabaseR.PRIMARY.7.001of001.20060701095634..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE FILEGROUP DATABASE "DatabaseR" OBJECTNAME "DBR_FG2" # The following image is type: Filegroup NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.fg.DatabaseR.DBR_FG2.7.001of001.20060701095425..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE FILE DATABASE "DatabaseR" OBJECTNAME "DBR_FG1_File1" # The following image is type: File NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.fil.DatabaseR.DBR_FG1_File1.7.001of001. 20060701100824..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE FILE DATABASE "DatabaseR" OBJECTNAME "DBR_FG1_File2" # The following image is type: File NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.fil.DatabaseR.DBR_FG1_File2.7.001of001. 20060701100908..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE FILE DATABASE "DatabaseR" OBJECTNAME "DBR_FG1_File3" # The following image is type: File NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.fil.DatabaseR.DBR_FG1_File3.7.001of001. 20060701100953..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE TRXLOG DATABASE "DatabaseR" # The following image is type: transaction log NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.trx.DatabaseR.~.7.001of001.20060701100030..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE TRXLOG DATABASE "DatabaseR" # The following image is type: transaction log NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.trx.DatabaseR.~.7.001of001.20060701110015..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE RECOVERED ENDOPER TRUE
More Information