|
jpotucek (TechnicalUser) |
21 Jul 11 13:35 |
Attemping to restore a backup made on one MS SQL Server 2005 Instance and restore to another.
Here is my script:
# OPERATION RESTORE OBJECTTYPE DATABASE RESTORETYPE MOVE DATABASE "ORION" # # Replace the file path <F:\MSSQL\KOCSQLDEV02\Default\Datafiles\Orion.mdf> # with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>. # The target of the MOVE keyword must be "Orion_Data". MOVE "Orion_Data" TO "F:\MSSQL\KOCSQLDEV03\Default\Datafiles\Orion.mdf" # # # Replace the file path <G:\MSSQL\KOCSQLDEV02\Default\Logfiles\Orion_log.ldf> # with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>. # The target of the MOVE keyword must be "Orion_Log". MOVE "Orion_Log" TO "G:\MSSQL\KOCSQLDEV03\Default\Logfiles\Orion_log.ldf" # # The following image is type: Full NBIMAGE "KOCSQLDEV02.MSSQL7.KOCSQLDEV02.db.ORION.~.7.001of001.20110719071613..C" SQLHOST "KOCSQLDEV03" NBSERVER "KOCBKUP02" BROWSECLIENT "KOCSQLDEV02" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE RECOVERED NUMBUFS 2 ENDOPER TRUE
and here is my error:
INF - RESTORE STARTED USING Microsoft SQL Server 2005 - 9.00.4226.00 (X64) May 26 2009 14:58:11 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7600: ) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Orion_Restore.bch, Op# = 1. INF - Using backup image KOCSQLDEV02.MSSQL7.KOCSQLDEV02.db.ORION.~.7.001of001.20110719071613..C INF - restore database "ORION" from VIRTUAL_DEVICE='VNBU0-5516-9104-1311258624' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'Orion_Data' to 'F:\MSSQL\KOCSQLDEV03\Default\Datafiles\Orion.mdf', move 'Orion_Log' to 'G:\MSSQL\KOCSQLDEV03\Default\Logfiles\Orion_log.ldf', replace INF - Number of stripes: 1, Number of buffers per stripe 2. INF - Created VDI object for SQL Server instance <KOCSQLDEV03>. Connection timeout is <300> seconds. ERR - Error in VxBSAQueryObject: 3. CONTINUATION: - System detected error, operation aborted. ERR - Error in VDS->Close: 0x8077000d. CONTINUATION: - All devices are open INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Orion_Restore.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 9(9) seconds.
Can anyone help me make heads or tails of this??
|
|