sql2005 差备全恢复，报一号错！数据库不能使用

rand1985

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' with  stats = 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><[Microsoft][SQL Native Client][SQL Server]10 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]20 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]30 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]40 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]50 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]60 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]70 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]80 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]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' with  stats = 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 [7040.5324] <4> : 14:58:09 (381054.001) INF - Waiting for mount of media id IM0151 on server sccfile02103 for reading.
14:59:07.889 [7040.5324] <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><[Microsoft][SQL Native Client][SQL Server]This differential backup cannot be restored because the database has not been restored to the correct earlier state.>.
DBMS MSG - SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]RESTORE DATABASE is terminating abnormally.>
ERR - Error found executing <restore database "CCMS" from VIRTUAL_DEVICE='VNBU0-7040-7816-1356073071' with  stats = 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

rand1985

问题已解决：
     sql2005备份的时候除了使用NBU备份 还使用NetApp的snapmanager去备份sql数据库， 据说snapmanager 会截断sql数据库的日志。
  各位，能有座存储的能介绍下snapmanager的工作机制么？  在这里先谢谢了