# # This is a template for the database MOVE command. # OPERATION RESTORE OBJECTTYPE DATABASE RESTORETYPE MOVE # # Replace the database name in the following line with the name of the database that you # want to move to. Also remove the hash mark <#> which precedes the keyword . # DATABASE "WSS_Content_test" # # Replace the file path # with a new file path. Also remove the hash mark <#> which precedes the keyword . # The target of the MOVE keyword must be "WSS_Content". MOVE "WSS_Content" TO "S:\bak_temp\WSS_Content.mdf" # # # Replace the file path # with a new file path. Also remove the hash mark <#> which precedes the keyword . # The target of the MOVE keyword must be "WSS_Content2". MOVE "WSS_Content2" TO "S:\bak_temp\WSS_Content2.ndf" # # # Replace the file path # with a new file path. Also remove the hash mark <#> which precedes the keyword . # The target of the MOVE keyword must be "WSS_Content_log". MOVE "WSS_Content_log" TO "S:\bak_temp\WSS_Content_log.LDF" # # The following image is type: Full NBIMAGE "SIH-SQLSRV2.MSSQL7.SIH-SQLSPDB\SPSQLSERVER.db.WSS_Content.~.7.001of003.20140330022419..C" SQLHOST "SIH-SQLSPDB" SQLINSTANCE "SPSQLSERVER" NBSERVER "SIH-NETBACKUP" STRIPES 003 BROWSECLIENT "SIH-SQLSPDB" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED NUMBUFS 2 ENDOPER TRUE OPERATION RESTORE OBJECTTYPE DATABASE DUMPOPTION INCREMENTAL RESTORETYPE MOVE # # Replace the database name in the following line with the name of the database that you # want to move to. Also remove the hash mark <#> which precedes the keyword . # DATABASE "WSS_Content_test" # The following image is type: Full database differential NBIMAGE "SIH-SQLSRV2.MSSQL7.SIH-SQLSPDB\SPSQLSERVER.inc.WSS_Content.~.7.001of003.20140330101635..C" SQLHOST "SIH-SQLSPDB" SQLINSTANCE "SPSQLSERVER" NBSERVER "SIH-NETBACKUP" STRIPES 003 BROWSECLIENT "SIH-SQLSPDB" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE RECOVERED NUMBUFS 2 ENDOPER TRUE INF - RESTORE STARTED USING Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) Batch = D:\wss_content.bch, Op# = 1. INF - Restoring from <3> images. The first is . INF - restore database "WSS_Content_test" from VIRTUAL_DEVICE='VNBU0-1688-6132-1396227929', VIRTUAL_DEVICE='VNBU1-1688-6132-1396227929', VIRTUAL_DEVICE='VNBU2-1688-6132-1396227929' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 6, replace , norecovery, move 'WSS_Content' to 'S:\bak_temp\WSS_Content.mdf', move 'WSS_Content2' to 'S:\bak_temp\WSS_Content2.ndf', move 'WSS_Content_log' to 'S:\bak_temp\WSS_Content_log.LDF', replace INF - Number of stripes: 3, Number of buffers per stripe 2. INF - Created VDI object for SQL Server instance . Connection timeout is <300> seconds. Restore started Mon Mar 31 09:05:31 2014 INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 10。>. INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 20。>. INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 30。>. INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 40。>. INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 50。>. INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 60。>. INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 70。>. INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 80。>. INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 90。>. INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 100。>. INF - SQL Message <4035><[Microsoft][ODBC SQL Server Driver][SQL Server]已为数据库 'WSS_Content_test',文件 'WSS_Content' (位于文件 1 上)处理了 792176 页。> INF - SQL Message <4035><[Microsoft][ODBC SQL Server Driver][SQL Server]已为数据库 'WSS_Content_test',文件 'WSS_Content2' (位于文件 1 上)处理了 78816 页。> INF - SQL Message <4035><[Microsoft][ODBC SQL Server Driver][SQL Server]已为数据库 'WSS_Content_test',文件 'WSS_Content_log' (位于文件 1 上)处理了 1 页。> INF - Thread has been closed for stripe #1 INF - Thread has been closed for stripe #2 INF - Thread has been closed for stripe #0 INF - OPERATION #1 of batch D:\wss_content.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 913(855) seconds INF - RESTORE STARTED USING Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) Batch = D:\wss_content.bch, Op# = 2. INF - Restoring from <3> images. The first is . INF - restore database "WSS_Content_test" from VIRTUAL_DEVICE='VNBU0-1688-7688-1396228843', VIRTUAL_DEVICE='VNBU1-1688-7688-1396228843', VIRTUAL_DEVICE='VNBU2-1688-7688-1396228843' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 6, replace , norecovery INF - Number of stripes: 3, Number of buffers per stripe 2. INF - Created VDI object for SQL Server instance . Connection timeout is <300> seconds. INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 18。>. INF - SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 37。> INF - SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 55。> INF - SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 74。> INF - SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 92。> ERR - Error in VxBSAGetData: 3. CONTINUATION: - System detected error, operation aborted. INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理百分之 100。>. ERR - Internal error. See the dbclient log for more information. ERR - Error in DBthreads::dbclient: 6. CONTINUATION: - The system cannot find the file specified. ERR - Error in VxBSAEndData: 6. CONTINUATION: - The handle used to associate this call with a previous VxBSAInit() call is invalid.