sql2005 差备全恢复，报一号错！数据库不能使用
sql 数据库恢复，子作业状态为0.但是父作业却为1，为部分完成。数据库不能使用。特上来请教各位高手！附上client端的user_ops日志信息。
#
#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>.
#
DATABASE "CCMS"
#
#Replace the file path <J:\ccms.mdf>
#with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#The target of the MOVE keyword must be "InternalPlatform_Data".
MOVE"InternalPlatform_Data"
TO"D:\SQLDatabase\ccms.mdf"
#
#
#Replace the file path <J:\ccms_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 "InternalPlatform_Log".
MOVE"InternalPlatform_Log"
TO"D:\SQLDatabase\ccms_log.ldf"
#
# The following image is type: Full
NBIMAGE "scccmsdbc02101.MSSQL7.CCMSSQLCLU2\CCMS.db.CCMS.~.5.001of001.20121218022148..C"
SQLHOST "SCCDBLB02101"
NBSERVER "SCCFILE02103"
BROWSECLIENT "ccmssqlclu2"
MAXTRANSFERSIZE 6
BLOCKSIZE 5
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>.
#
DATABASE "CCMS"
# The following image is type: Full database differential
NBIMAGE "scccmsdbc02101.MSSQL7.CCMSSQLCLU2\CCMS.inc.CCMS.~.5.001of001.20121220020754..C"
SQLHOST "SCCDBLB02101"
NBSERVER "SCCFILE02103"
BROWSECLIENT "ccmssqlclu2"
MAXTRANSFERSIZE 6
BLOCKSIZE 5
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE
INF - RESTORE STARTED USING
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = C:\Documents and Settings\Administrator\Desktop\restore ccms1220.bch, Op# = 1.
INF - Using backup image scccmsdbc02101.MSSQL7.CCMSSQLCLU2\CCMS.db.CCMS.~.5.001of001.20121218022148..C
INF - restore database "CCMS" from VIRTUAL_DEVICE='VNBU0-7040-880-1356062099' withstats = 10, blocksize = 16384, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'InternalPlatform_Data' to 'D:\SQLDatabase\ccms.mdf', move 'InternalPlatform_Log' to 'D:\SQLDatabase\ccms_log.ldf', replace
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <SCCDBLB02101>. Connection timeout is <300> seconds.
Restore started Fri Dec 21 11:55:01 2012
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><10 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><20 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><30 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><40 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><50 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><60 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><70 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><80 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><90 percent processed.>.
INF - Thread has been closed for stripe #0
INF - OPERATION #1 of batch C:\Documents and Settings\Administrator\Desktop\restore ccms1220.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 10969(0) seconds
INF - RESTORE STARTED USING
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = C:\Documents and Settings\Administrator\Desktop\restore ccms1220.bch, Op# = 2.
INF - Using backup image scccmsdbc02101.MSSQL7.CCMSSQLCLU2\CCMS.inc.CCMS.~.5.001of001.20121220020754..C
INF - restore database "CCMS" from VIRTUAL_DEVICE='VNBU0-7040-7816-1356073071' withstats = 10, blocksize = 16384, maxtransfersize = 4194304, buffercount = 2, replace , norecovery
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <SCCDBLB02101>. Connection timeout is <300> seconds.
14:58:10.873 <4> : 14:58:09 (381054.001) INF - Waiting for mount of media id IM0151 on server sccfile02103 for reading.
14:59:07.889 <4> : 14:59:07 (381054.001) INF - Waiting for positioning of media id IM0151 on server sccfile02103 for reading.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3136><This differential backup cannot be restored because the database has not been restored to the correct earlier state.>.
DBMS MSG - SQL Message <3013><RESTORE DATABASE is terminating abnormally.>
ERR - Error found executing <restore database "CCMS" from VIRTUAL_DEVICE='VNBU0-7040-7816-1356073071' withstats = 10, blocksize = 16384, maxtransfersize = 4194304, buffercount = 2, replace , norecovery>.
ERR - Error in VDS->Close: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #2 of batch C:\Documents and Settings\Administrator\Desktop\restore ccms1220.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 216(0) seconds.
INF - Results of executing <C:\Documents and Settings\Administrator\Desktop\restore ccms1220.bch>:
<1> operations succeeded. <1> operations failed.
INF - Thread has been closed for stripe #0
问题已解决：
sql2005备份的时候除了使用NBU备份 还使用NetApp的snapmanager去备份sql数据库， 据说snapmanager 会截断sql数据库的日志。
各位，能有座存储的能介绍下snapmanager的工作机制么？在这里先谢谢了
页:
[1]