一个使用NetBackup restore MS SQL Server 的错误，请大家帮忙解释一下，谢谢

newplayer

Netbackup version : 6.0mp1
SQL Server :2000

我使用Netbackup 6.0mp1 备份了生产环境的一个测试库，在测试环境下进行恢复测试。两边的环境都是 windows 2000 server ,SQL Server 2000。

在生产环境下进行数据库全备份成功完成，进行增量备份时显示的是部分完成。对于这个原因我猜测是因为有的数据库设置的是简单模式造成的。（因为对于SQL server不是很熟悉的缘故，我的猜测如果有什么不对的地方，请大家指教）

在测试环境中尝试进行恢复，全备份能够完全恢复，而增量恢复不能够恢复（使用的是那些增量备份成功的image恢复也是失败的）。以下是恢复的log


OPERATION RESTORE
OBJECTTYPE DATABASE
DATABASE "smis2ext"
# The following image is type: Full
NBIMAGE "smis02.MSSQL7.SMIS02.db.smis2ext.~.7.001of001.20060628174111..C"
SQLHOST "SQLSVR"
NBSERVER "BACKUPSVR"
BROWSECLIENT "smis02"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE NOTRECOVERED
ENDOPER TRUE
OPERATION RESTORE
OBJECTTYPE DATABASE
DUMPOPTION INCREMENTAL
DATABASE "smis2ext"
# The following image is type: Full database differential
NBIMAGE "smis02.MSSQL7.SMIS02.inc.smis2ext.~.7.001of001.20060701164544..C"
SQLHOST "SQLSVR"
NBSERVER "BACKUPSVR"
BROWSECLIENT "smis02"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
ENDOPER TRUE


INF - RESTORE STARTED USING
Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Batch = C:\Program Files\VERITAS\NetBackup\dbext\mssql\temp\__18_03_15_312_00.bch, Op# = 1.
INF - Using backup image smis02.MSSQL7.SMIS02.db.smis2ext.~.7.001of001.20060628174111..C
INF - restore database "smis2ext" from VIRTUAL_DEVICE='VNBU0-812-2892-1151748197' with blocksize = 65536, maxtransfersize = 65536, buffercount = 1, replace , norecovery
INF - Number of stripes: 1, Number of buffers per stripe 1.
INF - Created VDI object for SQL Server instance <SQLSVR>. Connection timeout is <300> seconds.
Restore started Sat Jul 01 18:03:18 2006


18:03:25 (437.001) Restoring from image created 06/28/06 17:43:05
18:03:29 (437.001) INF - Data socket = BACKUPSVR.IPC:1246;cb8e1138dc2fa0fdcd670580fbeb59ca;4;300
18:03:29 (437.001) INF - Name socket = BACKUPSVR.IPC:1247;95a76eb4e321b8cb579f9ff88d4b9850;4;300
18:03:29 (437.001) INF - Job id = 437
18:03:30 (437.001) INF - Backup id = smis02_1151487785
18:03:30 (437.001) INF - Backup time = 1151487785
18:03:30 (437.001) INF - Policy name = Smis02_backupsvr_SQL_Full
18:03:30 (437.001) INF - Snapshot = 0
18:03:31 (437.001) INF - Frozen image = 0
18:03:31 (437.001) INF - Backup copy = 0
18:03:31 (437.001) INF - Master server = backupsvr
18:03:31 (437.001) INF - Use shared memory = 0
18:03:32 (437.001) INF - Restore id = 437.001
18:03:32 (437.001) INF - Encrypt = 0
18:03:32 (437.001) INF - Client read timeout = 300
18:03:32 (437.001) INF - Media mount timeout = 0
18:03:33 (437.001) INF - client = sqlsvr
18:03:33 (437.001) INF - requesting_client = sqlsvr
18:03:33 (437.001) INF - browse_client = smis02
18:03:41 (437.001) INF - Beginning restore from server backupsvr to client sqlsvr, file E:\Data\SQL_Backup_Full\smis02_1151487785_C1_F1.
18:03:54 /smis02.MSSQL7.SMIS02.db.smis2ext.~.7.001of001.20060628174111..C
18:03:59 (437.001) Status of restore from image created 06/28/06 17:43:05 = the requested operation was successfully completed

INF - ODBC return code <2>, SQL State <01000>, SQL Message <4035><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理 9256 页，这些页属于数据库 'smis2ext' 的文件 'smis2ext_Data'（位于文件 1 上）。>.
INF - SQL Message <4035><[Microsoft][ODBC SQL Server Driver][SQL Server]已处理 1 页，这些页属于数据库 'smis2ext' 的文件 'smis2ext_Log'（位于文件 1 上）。>
18:04:01 INF - Server status = 0
18:04:03 (437.xxx) INF - Status = the requested operation was successfully completed.

INF - Thread has been closed for stripe #0
INF - OPERATION #1 of batch C:\Program Files\VERITAS\NetBackup\dbext\mssql\temp\__18_03_15_312_00.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 52(0) seconds
INF - RESTORE STARTED USING
Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Batch = C:\Program Files\VERITAS\NetBackup\dbext\mssql\temp\__18_03_15_312_00.bch, Op# = 2.
INF - Using backup image smis02.MSSQL7.SMIS02.inc.smis2ext.~.7.001of001.20060701164544..C
INF - restore database "smis2ext" from VIRTUAL_DEVICE='VNBU0-812-2892-1151748251' with blocksize = 65536, maxtransfersize = 65536, buffercount = 1, replace , norecovery
INF - Number of stripes: 1, Number of buffers per stripe 1.
INF - Created VDI object for SQL Server instance <SQLSVR>. Connection timeout is <300> seconds.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3136><[Microsoft][ODBC SQL Server Driver][SQL Server]无法将设备 'VNBU0-812-2892-1151748251' 上的备份应用于数据库 'smis2ext'。>.
DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE 操作异常终止。>
ERR - Error found executing <restore database "smis2ext" from VIRTUAL_DEVICE='VNBU0-812-2892-1151748251' with blocksize = 65536, maxtransfersize = 65536, buffercount = 1, replace , norecovery>.
ERR - Error in VxBSAEndData: 3.
    CONTINUATION: - System detected error, operation aborted.
ERR - Error in VDS->Close: 0x80770004.
    CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #2 of batch C:\Program Files\VERITAS\NetBackup\dbext\mssql\temp\__18_03_15_312_00.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 185(0) seconds.
INF - Results of executing <C:\Program Files\VERITAS\NetBackup\dbext\mssql\temp\__18_03_15_312_00.bch>:
<1> operations succeeded. <1> operations failed.


请有这方面经验的朋友帮忙看看，谢谢

newplayer

原因早就找到了，我忘了更新了，好久没上来了...

恢复失败的原因是 我在用NBU对SQLserver进行全备份后又在SQLserver上提交了一个手动全备份，最后又使用NBU进行了增量备份，也就是说这个增量备份是相对于SQL Server那次手动全备份的增量备份。

在恢复的时候当然NBU找不到与增量相对应的全备份了...犯了个低级错误....

[ 本帖最后由 newplayer 于 2008-11-27 17:06 编辑 ]