我们如何将备份从一个系统恢复到另一个系统sql sever ..？ [英] how do we restore backup from one system to another system sql sever..?

问题描述

我有两个系统ip..Both将有sql server我想恢复一个系统备份到另一个systam ..在widows os上运行并安装了sql 2008 r2 ..有可能做到这一点。请解释过程..

解决方案

HI，希望这会有所帮助：



http://help.bizagi.com/bpmsuite/en/index.html?when_using_sql_server.htm [<一个href =http://help.bizagi.com/bpmsuite/en/index.html?when_using_sql_server.htmtarget =_ blanktitle =新窗口> ^ ]

在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.

这篇关于我们如何将备份从一个系统恢复到另一个系统sql sever ..？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！