如何将备份从一台服务器SERERA还原到另一台服务器SERVERB. [英] How to restore backup from one server SERERA to another server SERVERB.

问题描述

我在服务器A上有日常维护计划备份(A，B，C，D数据库).我想在生产服务器(即服务器B)上自动或使用调度程序或任何其他维护计划来还原该备份.
两台服务器都使用SQL SERVER 2008 R2.
我该如何实现?我看过很多文章，但没人见过.
谢谢，
Mangesh:-)

I have daily maintenance schedule backup(A,B,C,D databases) on my SERVER A. I want to restore that backup on my production server i;e SERVER B automatically or using scheduller or any other maintenance plan.
Both Servers are using SQL SERVER 2008 R2.
How I achieve? i have seen lot of article but no one having fruitfull.
Thanks,
Mangesh :-)

推荐答案

一种方法是使用SQL Agent安排新作业并执行 http://msdn.microsoft.com/en-us/library/ms186273 .aspx [^ ]

One way is to schedule a new job using SQL Agent and execute a RESTORE[^] operation to your target database.

To create a job, refer to http://msdn.microsoft.com/en-us/library/ms186273.aspx[^]

我不知道为什么您无法找到此类信息.但谷歌给了我一个非常好的链接.我不想再发布链接.

只需参考此 [ ^ ]

希望对您有帮助，
谢谢
-Amit Gajjar

Hi,

i don''t know why you are not able to find out such information. but google gives me really good link. i do not want to post anymore link.

Just refer this[^]

Hope it helps you,
Thanks
-Amit Gajjar

这篇关于如何将备份从一台服务器SERERA还原到另一台服务器SERVERB.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！