恢复sqlserver报错

lcrash

备份Sql server 单独数据库glp，然后备份总能成功，恢复总是报错，求教各位大侠，看看什么情况啊


OPERATION RESTORE
OBJECTTYPE DATABASE
DATABASE "glp"
# The following image is type: Full
NBIMAGE "sql2005.MSSQL7.SQL2005\MYINSTANCE.db.glp.~.7.001of001.20120418194239..C"
SQLHOST "SQL2005"
SQLINSTANCE "MYINSTANCE"
NBSERVER "NBUSERVER"
BROWSECLIENT "sql2005"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

INF - RESTORE STARTED USING
Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
Oct 14 2005 00:35:21
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__19_43_49_106_00.bch, Op# = 1.
INF - Using backup image sql2005.MSSQL7.SQL2005\MYINSTANCE.db.glp.~.7.001of001.20120418194239..C
INF - restore database "glp" from VIRTUAL_DEVICE='VNBU0-2464-1028-1334749430' with  stats = 10, blocksize = 65536, 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 <MYINSTANCE>. Connection timeout is <300> seconds.
Restore started Wed Apr 18 19:43:50 2012

DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3101><[Microsoft][SQL Native Client][SQL Server]因为数据库正在使用，所以无法获得对数据库的独占访问权。>.
DBMS MSG - SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]RESTORE DATABASE 正在异常终止。>
ERR - Error found executing <restore database "glp" from VIRTUAL_DEVICE='VNBU0-2464-1028-1334749430' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery>.
ERR - Error in VDS->Close: 0x80770004.
    CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__19_43_49_106_00.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 34(34) seconds.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__19_43_49_106_00.bch>:
<0> operations succeeded. <1> operations failed.

lcrash

晕倒，重新启动一次sqlserver的服务就可以还原了，学艺不精啊

myguangzhou

跟重启服务器没什么关系
恢复失败是因为有用户在访问SQLSERVER，你重启之后连接都断开了，就可以恢复了；其实你可以在数据库里把客户端连接清除掉，然后再恢复的哦，没必要REBOOT OS

lcrash

呵呵，我是重启的sqlserver的服务，不是服务器哈
相当于sqlserver关闭了连接回复 3# myguangzhou


   

myguangzhou

不都一样吗

Deafa

刚刚遇到这个问题，绕了半小时解决了，怎么地在这猫着呢，来晚一步。

haieven

回复 2# lcrash


    我这边备份还没成功呢，sql的备份，策略选的是ms-sql-server,备份日志的时候总是报错，这是哪地方出问题了呢