如何将数据库从一台服务器还原到另一台服务器。 [英] how to restore the database from one server to another server.

问题描述

我有两台服务器我想从一台服务器恢复到另一台服务器可能..？

I have two server i want to restore from one server to another server that is possible..?

推荐答案

您可以使用SQL Server的服务器到服务器导入/导出工具。这是将数据库从一个SQL服务器传输到另一个SQL Server的最简单方法。



请参阅以下链接了解更多信息。



http://www.mssqltips.com/sqlservertutorial/202/simple-way-to-export-data -from-sql-server / [ ^ ]





如果您有任何疑问，请告知我们。查询。



谢谢

Advay Pandya

Hi,

You can use server to server Import/Export tool of SQL server. This is the simplest way to transfer database from one SQL server to another.

Please refer below link for more information.

http://www.mssqltips.com/sqlservertutorial/202/simple-way-to-export-data-from-sql-server/[^]


Please let me know of you have any concern or query on this.

Thanks
Advay Pandya

按照此链接进行数据库备份和重新启动，

https://msdn.microsoft.com/en-us/ms177429.aspx [ ^ ]

Follow this link for database backup and resote,
https://msdn.microsoft.com/en-us/ms177429.aspx[^]

您好，



您可以创建共享文件夹并在此文件夹中进行备份。在恢复操作期间，可以从其他服务器浏览此文件夹。



谢谢，

Vineet

Hi,

You can create a shared folder and take the backup in this folder. This folder can be browsed from other servers during the restore operation.

Thanks,
Vineet

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