如何在 SQL Server 2008 Express 的同一台服务器上克隆 SQL Server 数据库? [英] How can I clone an SQL Server database on the same server in SQL Server 2008 Express?

问题描述

我有一个 MS SQL Server 2008 Express 系统，其中包含一个我想复制和重命名"(用于测试目的)的数据库，但我不知道实现此目的的简单方法.

I have an MS SQL Server 2008 Express system which contains a database that I would like to 'copy and rename' (for testing purposes) but I am unaware of a simple way to achieve this.

我注意到在 R2 版本的 SQL Server 中有一个复制数据库向导，但遗憾的是我无法升级.

I notice that in the R2 version of SQL Server there is a copy database wizard, but sadly I can't upgrade.

有问题的数据库是一场演出.我尝试将要复制到新数据库中的数据库的备份还原，但没有成功.

The database in question is around a gig. I attempted to restore a backup of the database I want to copy into a new database, but with no luck.

推荐答案

结果是我错误地尝试从备份中恢复.

It turns out that I had attempted to restore from a backup incorrectly.

最初我创建了一个新数据库，然后尝试在此处恢复备份.我应该做的，以及最终奏效的，是打开恢复对话框并在目标字段中输入新数据库的名称.

Initially I created a new database and then attempted to restore the backup here. What I should have done, and what worked in the end, was to bring up the restore dialog and type the name of the new database in the destination field.

所以，简而言之，从备份恢复就行了.

So, in short, restoring from a backup did the trick.

感谢大家的反馈和建议

这篇关于如何在 SQL Server 2008 Express 的同一台服务器上克隆 SQL Server 数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！