sql-server - SQL Server : how do I export entire database?

Question

我需要从一台服务器导出数据库并将其导入另一台服务器。

1. 如何将整个数据库导出到一个文件或两个文件 mdf、ldf(任一选项都可以)
2. 如何使用 ssms 将其导入新服务器？

在小马的说明书中，它说:

In the To a point in time text box, either retain the default (Most recent possible) or select a specific date and time by clicking the browse button, which opens the Point in Time Restore dialog box. For more information, see How to: Restore to a Point in Time (SQL Server Management Studio).

To specify the source and location of the backup sets to restore, click one of the following options:

From database

Enter a database name in the list box.

我无法在恢复中输入任何内容

https://stackoverflow.com/questions/3241108/i-backed-up-the-database-in-ssms-sql-server-how-do-i-restore-it

Answer 1

使用 SQL Server Management Studio，您可以使用备份/恢复功能。 The Restore process is laid out in the MSDN documentation.和here's the MSDN article for backing up a database...

显然，您恢复到另一个SQL Server数据库实例(一个“数据库实例”可以包含多个数据库。)。实例的版本可以比备份来源的版本更新 - 兼容性级别将进行相应设置。