如何从sql 2005 Express Edition复制/复制数据库 [英] how to copy/ duplicate a Database from sql 2005 express Edition

问题描述

谁能告诉我如何使数据库副本与现有副本相同.
我可以在数据库->任务中找到复制数据库.它不存在.

是另一种方式.

请紧迫...

can any body tell me how to make copy of database same as existing.
i can find copy database in database --> task. it is not present.

is another way to do it..

plz it''s urgent...

推荐答案

备份数据库.

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

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

确保在还原选项中标记为覆盖现有数据库"，并选择正确的文件(副本数据库中的文件).

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

这篇关于如何从sql 2005 Express Edition复制/复制数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！