且构网

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

如何从sql 2005 Express Edition复制/复制数据库

更新时间:2023-02-02 21:57:53

备份数据库.

然后创建一个新数据库(这将是副本)

然后还原新数据库(副本)并使用原始数据库的备份.

确保在还原选项中标记为覆盖现有数据库",并选择正确的文件(副本数据库中的文件).
Make a backup of the database.

Then make a new database (this is going to be the copy)

Then restore your new database (the copy) and use the backup of the original.

Make sure that in the options of the restore you mark ''overwrite existing database'' and that you select the correct files (the ones from your copy database).