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??
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??