sql 2008R2 异机恢复

yoyosys

有人做过Win2008R2 sql 2008R2 异机恢复么？我这边怎么不成功呢
环境：
master:655
客户端：656

ry715

也不说啥错呀

赵大少爷

master太低了

yoyosys

本地恢复正常，异机恢复报如下错误：
# The following image is type: Full database differential
NBIMAGE "SPS-2010DB01.MSSQL7.SPS-2010DB01.inc.WSS_Content.~.7.001of001.20101223090657..C"
SQLHOST "SPS-2010DB01"
NBSERVER "NBUMASTER"
BROWSECLIENT "SPS-2010DB01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
ENDOPER TRUE

INF - RESTORE STARTED USING
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr  2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
Batch = C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__11_11_53_640_00.bch, Op# = 1.
INF - Using backup image SPS-2010DB01.MSSQL7.SPS-2010DB01.db.WSS_Content.~.7.001of001.20101222120139..C
INF - restore database "WSS_Content" from VIRTUAL_DEVICE='VNBU0-2360-5440-1293160315' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 1, replace , norecovery
INF - Number of stripes: 1, Number of buffers per stripe 1.
INF - Created VDI object for SQL Server instance <SPS-2010DB01>. Connection timeout is <300> seconds.
ERR - Error in GetConfiguration: 0x80770003.
    CONTINUATION: - The api was waiting and the timeout interval had elapsed.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3201><[Microsoft][ODBC SQL Server Driver][SQL Server]无法打开备份设备 'VNBU0-2360-5440-1293160315'。出现操作系统错误 0x80070002(系统找不到指定的文件。)。>.
DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE 正在异常终止。>
ERR - Error found executing <restore database "WSS_Content" from VIRTUAL_DEVICE='VNBU0-2360-5440-1293160315' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 1, 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\__11_11_53_640_00.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 308(30 seconds.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__11_11_53_640_00.bch>:
<0> operations succeeded. <1> operations failed.


我这边正准备搭个7测试环境

ry715

你做异机恢复的这个机器，你最好先测试一下，看看自己备份自己和恢复自己的SQL是不是OK

yoyosys

你做异机恢复的这个机器，你最好先测试一下，看看自己备份自己和恢复自己的SQL是不是OK
ry715 发表于 2011-01-05 11:35

自己恢复自己是没有问题的

撒旦的使者

看看操作系统上有什么错误

ry715

solution:更改NBU CLIENT SERVICE 为登录的域帐号

看看这个方式是否可以

ry715

需要增加CLIENT_READ_TIMEOUT = 3600并且关掉SQL SERVER的企业级管理工具界面

这个是另外一个方法，hoho

ry715

http://www.symantec.com/business ... nt&id=TECH34693

看看有用没