且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

我们如何将备份从一个系统恢复到另一个系统sql sever ..?

更新时间:2023-11-27 22:22:16

HI,希望这会有所帮助:



http://help.bizagi.com/bpmsuite/en/index.html?when_using_sql_server.htm [ ^ ]


在SQL Server中备份和恢复数据库 [ ^ ]似乎是一个不错的开始地方。



CodeProject有很多相关文章 [ ^ ]。


你可以分离来自源的数据库和附加它在目标服务器中。它是一个离线进程,它移动数据库而不是复制它。


I have two system ip..Both will have sql server i want to restore one system back up into antother systam..both running on widows os and installed sql 2008 r2..is it possible to do that..please explain the process..

HI, hope this will help:

http://help.bizagi.com/bpmsuite/en/index.html?when_using_sql_server.htm[^]


Backing Up and Restoring Databases in SQL Server[^] seems a decent starting place.

CodeProject has a lot of related articles[^], too.


You can Detach the database from source and attach it in the destination server. it is an offline process of, it moves the database instead of copying it.