sql 2008R2 异机恢复
有人做过Win2008R2 sql 2008R2 异机恢复么？我这边怎么不成功呢环境：
master:655
客户端：656 也不说啥错呀 master太低了 本地恢复正常，异机恢复报如下错误：
# 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)
Apr2 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' withstats = 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><无法打开备份设备 'VNBU0-2360-5440-1293160315'。出现操作系统错误 0x80070002(系统找不到指定的文件。)。>.
DBMS MSG - SQL Message <3013><RESTORE DATABASE 正在异常终止。>
ERR - Error found executing <restore database "WSS_Content" from VIRTUAL_DEVICE='VNBU0-2360-5440-1293160315' withstats = 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(308) 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测试环境 你做异机恢复的这个机器，你最好先测试一下，看看自己备份自己和恢复自己的SQL是不是OK 你做异机恢复的这个机器，你最好先测试一下，看看自己备份自己和恢复自己的SQL是不是OK
ry715 发表于 2011-01-05 11:35 http://bbs.chinaunix.net/images/common/back.gif
自己恢复自己是没有问题的 看看操作系统上有什么错误 solution:更改NBU CLIENT SERVICE 为登录的域帐号
看看这个方式是否可以 需要增加CLIENT_READ_TIMEOUT = 3600并且关掉SQL SERVER的企业级管理工具界面
这个是另外一个方法，hoho http://www.symantec.com/business/support/index?page=content&id=TECH34693
看看有用没