当前位置：文江博客话题详情

sql 2008R2 异机恢复

发布于 2022-09-12 08:12:19 字数 81 浏览 8 评论 9

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

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

我的黑色迷你裙 2022-09-15 08:31:45

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

这个是另外一个方法，hoho

回复收藏 0

浮生未歇 2022-09-15 08:31:45

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

看看有用没

回复收藏 0

初见终念 2022-09-15 08:31:22

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

看看这个方式是否可以

回复收藏 0

我不会写诗 2022-09-15 07:57:48

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

回复收藏 0

她如夕阳 2022-09-15 07:31:48

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

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

回复收藏 0

漫漫岁月 2022-09-15 07:17:10

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

回复收藏 0

心在旅行 2022-09-15 07:09:56

本地恢复正常，异机恢复报如下错误：
# 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 FilesVeritasNetBackupdbextmssqltemp__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 FilesVeritasNetBackupdbextmssqltemp__11_11_53_640_00.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 308(30 seconds.
INF - Results of executing <C:Program FilesVeritasNetBackupdbextmssqltemp__11_11_53_640_00.bch>:
<0> operations succeeded. <1> operations failed.