blocks|key|1436411|text|分离数据库，复制.MDF文件(和.ldf文件)，然后可以同时附加这两个文件。或者只有一个，以保留一个作为副本，以便稍后快速复制。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1436412|Mcirosoft+SQL+Server+Management+Studio中的"Copy+database“命令也可以这样工作。|1436413|您可以很容易地自动化/编写脚本，使用PowerShell或只使用.Cmd文件调用osql。|1436414|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Detach the database, copy the .MDF file (and .ldf file) and you can attach both. Or only one, to keep one as a copy for a fast copy later.

The "Copy database" command from Mcirosoft SQL Server Management Studio can also work like this.

You can automate/script this easily, using PowerShell or just .Cmd files with calls to osql.

blocks|key|1650993|text|您还可以使用SQL+Management+Studio+UI创建文件备份，然后将其还原到同一服务器或任何其他服务器上的新数据库中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1650994|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

And you can also use the SQL Management Studio UI to create a file backup, and then restore it into a new database on the same or any other server.

blocks|key|1651031|text|在SQL2005中，我认为最快的方法是使用数据库-->任务下的复制数据库|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1651032|源和目标可以是相同的，如果需要，它允许您重命名数据库。|1651033|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

In SQL 2005, I would say the fastest way is to use Copy Database, under Database --> Tasks

The source and destination can be the same, and it allows you to rename the database if desired.

blocks|key|1436358|text|有一个用于创建和恢复数据库的命令行工具(DOS)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1436359|您也可以将其作为T-SQL脚本执行。http://www.sqlmag.com/Article/ArticleID/46560/sql_server_46560.html|offset|length|1436360|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlmag.com/Article/ArticleID/46560/sql_server_46560.html^0|0|I|1V|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

There's a command line tool (DOS) for creating and restoring databases.

Also you can perform this as T-SQL script. 
<a href="http://www.sqlmag.com/Article/ArticleID/46560/sql_server_46560.html" rel="nofollow noreferrer">http://www.sqlmag.com/Article/ArticleID/46560/sql_server_46560.html</a>

blocks|key|1651065|text|我会使用脚本，因为这有助于提高你所做的事情的透明度。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1651066|(特别是如果你想经常这样做，因为变化很大，每一个都会有略微不同的数据。)|1651067|但是，如果您不想麻烦地创建脚本，最简单的方法是备份，然后恢复到不同的名称。|1651068|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I would use scripts, as this aids transparency of what you're doing. 
(Especially if you want to do it often, as changes are each one will have slightly different data.)

However if you don't want to go to the hassle of creating the scripts, the easiest way is to backup and then restore to a different name.

blocks|key|1436588|text|如果你想编写脚本，你可以使用下面的代码。如果你不能让数据库离线，这也是最好的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1436589|USE+master
GO

--+the+original+database+(use+'SET+@DB+=+NULL'+to+disable+backup)
DECLARE+@DB+varchar(200)
SET+@DB+=+'PcTopp'

++++--+the+backup+filename
DECLARE+@BackupFile+varchar(2000)
SET+@BackupFile+=+'c:\pctopp\sqlserver\backup.dat'

--+the+new+database+name
DECLARE+@TestDB+varchar(200)
SET+@TestDB+=+'TestDB'

--+the+new+database+files+without+.mdf/.ldf
DECLARE+@RestoreFile+varchar(2000)
SET+@RestoreFile+=+'c:\pctopp\sqlserver\backup'


--+****************************************************************
--++++++++++++++++++++no+change+below+this+line
--+****************************************************************


DECLARE+@query+varchar(2000)

DECLARE+@DataFile+varchar(2000)
SET+@DataFile+=+@RestoreFile+%2B+'.mdf'

DECLARE+@LogFile+varchar(2000)
SET+@LogFile+=+@RestoreFile+%2B+'.ldf'

IF+@DB+IS+NOT+NULL
BEGIN
++++SET+@query+=+'BACKUP+DATABASE+'+%2B+@DB+%2B+'+TO+DISK+=+'+%2B+QUOTENAME(@BackupFile,+'''')
++++EXEC+(@query)
END

--+RESTORE+FILELISTONLY+FROM+DISK+=+'C:\temp\backup.dat'
--+RESTORE+HEADERONLY+FROM+DISK+=+'C:\temp\backup.dat'
--+RESTORE+LABELONLY+FROM+DISK+=+'C:\temp\backup.dat'
--+RESTORE+VERIFYONLY+FROM+DISK+=+'C:\temp\backup.dat'

IF+EXISTS(SELECT+*+FROM+sysdatabases+WHERE+name+=+@TestDB)
BEGIN
++++SET+@query+=+'DROP+DATABASE+'+%2B+@TestDB
++++EXEC+(@query)
END

RESTORE+HEADERONLY+FROM+DISK+=+@BackupFile
DECLARE+@File+int
SET+@File+=+@@ROWCOUNT

DECLARE+@Data+varchar(500)
DECLARE+@Log+varchar(500)

SET+@query+=+'RESTORE+FILELISTONLY+FROM+DISK+=+'+%2B+QUOTENAME(@BackupFile+,+'''')

CREATE+TABLE+#restoretemp
(
+LogicalName+varchar(500),
+PhysicalName+varchar(500),
+type+varchar(10),
+FilegroupName+varchar(200),
+size+int,
+maxsize+bigint
)
INSERT+#restoretemp+EXEC+(@query)

SELECT+@Data+=+LogicalName+FROM+#restoretemp+WHERE+type+=+'D'
SELECT+@Log+=+LogicalName+FROM+#restoretemp+WHERE+type+=+'L'

PRINT+@Data
PRINT+@Log

TRUNCATE+TABLE+#restoretemp
DROP+TABLE+#restoretemp

IF+@File+>+0
BEGIN
++++SET+@query+=+'RESTORE+DATABASE+'+%2B+@TestDB+%2B+'+FROM+DISK+=+'+%2B+QUOTENAME(@BackupFile,+'''')+%2B+
++++++++'+WITH+MOVE+'+%2B+QUOTENAME(@Data,+'''')+%2B+'+TO+'+%2B+QUOTENAME(@DataFile,+'''')+%2B+',+MOVE+'+%2B
++++++++QUOTENAME(@Log,+'''')+%2B+'+TO+'+%2B+QUOTENAME(@LogFile,+'''')+%2B+',+FILE+=+'+%2B+CONVERT(varchar,+@File)
++++EXEC+(@query)
END
GO|code-block|syntax|javascript|1436590|复制自：http://weblogs.asp.net/mschwarz/archive/2004/08/26/220735.aspx|offset|length|1436591|entityMap|0|LINK|mutability|MUTABLE|url|http://weblogs.asp.net/mschwarz/archive/2004/08/26/220735.aspx^0|0|0|4|1Q|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

If you want to script it you can use the following. This is also best if you can't take the db offline:

<pre><code>USE master
GO

-- the original database (use 'SET @DB = NULL' to disable backup)
DECLARE @DB varchar(200)
SET @DB = 'PcTopp'

 -- the backup filename
DECLARE @BackupFile varchar(2000)
SET @BackupFile = 'c:\pctopp\sqlserver\backup.dat'

-- the new database name
DECLARE @TestDB varchar(200)
SET @TestDB = 'TestDB'

-- the new database files without .mdf/.ldf
DECLARE @RestoreFile varchar(2000)
SET @RestoreFile = 'c:\pctopp\sqlserver\backup'


-- ****************************************************************
-- no change below this line
-- ****************************************************************


DECLARE @query varchar(2000)

DECLARE @DataFile varchar(2000)
SET @DataFile = @RestoreFile + '.mdf'

DECLARE @LogFile varchar(2000)
SET @LogFile = @RestoreFile + '.ldf'

IF @DB IS NOT NULL
BEGIN
 SET @query = 'BACKUP DATABASE ' + @DB + ' TO DISK = ' + QUOTENAME(@BackupFile, '''')
 EXEC (@query)
END

-- RESTORE FILELISTONLY FROM DISK = 'C:\temp\backup.dat'
-- RESTORE HEADERONLY FROM DISK = 'C:\temp\backup.dat'
-- RESTORE LABELONLY FROM DISK = 'C:\temp\backup.dat'
-- RESTORE VERIFYONLY FROM DISK = 'C:\temp\backup.dat'

IF EXISTS(SELECT * FROM sysdatabases WHERE name = @TestDB)
BEGIN
 SET @query = 'DROP DATABASE ' + @TestDB
 EXEC (@query)
END

RESTORE HEADERONLY FROM DISK = @BackupFile
DECLARE @File int
SET @File = @@ROWCOUNT

DECLARE @Data varchar(500)
DECLARE @Log varchar(500)

SET @query = 'RESTORE FILELISTONLY FROM DISK = ' + QUOTENAME(@BackupFile , '''')

CREATE TABLE #restoretemp
(
 LogicalName varchar(500),
 PhysicalName varchar(500),
 type varchar(10),
 FilegroupName varchar(200),
 size int,
 maxsize bigint
)
INSERT #restoretemp EXEC (@query)

SELECT @Data = LogicalName FROM #restoretemp WHERE type = 'D'
SELECT @Log = LogicalName FROM #restoretemp WHERE type = 'L'

PRINT @Data
PRINT @Log

TRUNCATE TABLE #restoretemp
DROP TABLE #restoretemp

IF @File &gt; 0
BEGIN
 SET @query = 'RESTORE DATABASE ' + @TestDB + ' FROM DISK = ' + QUOTENAME(@BackupFile, '''') + 
 ' WITH MOVE ' + QUOTENAME(@Data, '''') + ' TO ' + QUOTENAME(@DataFile, '''') + ', MOVE ' +
 QUOTENAME(@Log, '''') + ' TO ' + QUOTENAME(@LogFile, '''') + ', FILE = ' + CONVERT(varchar, @File)
 EXEC (@query)
END
GO
</code></pre>

Copied from: <a href="http://weblogs.asp.net/mschwarz/archive/2004/08/26/220735.aspx" rel="nofollow noreferrer">http://weblogs.asp.net/mschwarz/archive/2004/08/26/220735.aspx</a>

blocks|key|1436700|text|又多了一个选择，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1436701|这里有一篇博客文章，讲述了如何使用数据库发布向导，以及如何使用它将数据库的所有元素(包括数据)导出到SQL文件。可能会有帮助，而且看起来很简单。|1436702|http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/|offset|length|1436703|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|3F|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@$F|R|G|S|1|T]]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|E]]]]

One more option to throw in,

Here's a blog entry that talks about using the Database Publishing Wizard and how it's used to export all elements of a database, including data, to an SQL file. Might be helpful and seems pretty straightforward.

<a href="http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/" rel="nofollow noreferrer">http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/</a>

blocks|key|1436766|text|SQL+2005+-+quick+way+to+quickly+duplicate+a+database+%2B+data上面的帖子起作用了.|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1436767|但如果您正在使用sql+server+2008+r2，则可能需要对"create+table+#restoretemp“部分稍加修改，因为"restore+filelistonly...”的返回值已经改变了自从..。|1436768|基本上就是在"maxsize+bigint“之后添加这个|1436769|+maxsize+bigint,
+fileid+bigint,
+createlsn+numeric(26),
+droplsn+numeric(26),
+uniqueid+uniqueidentifier,
+readonlylsn+numeric(26),
+readwritelsn+numeric(26),
+BackupSizeInBytes+bigint,
+SourceBlockSize+int,
+FileGroupId+int,
+LogGroupGUID+uniqueidentifier,
+DifferentialBaseLSN+numeric(26),
+DifferentialBaseGUID+uniqueidentifier,
+IsReadOnly+bit,
+IsPresent+bit,
+TDEThumbprint+varbinary(40)|code-block|syntax|javascript|1436770|你最终会得到下面的工作脚本...|1436771|USE+master
GO

--+the+original+database+(use+'SET+@DB+=+NULL'+to+disable+backup)
DECLARE+@DB+varchar(200)
SET+@DB+=+'source_db_name'

--+the+backup+filename
DECLARE+@BackupFile+varchar(2000)
SET+@BackupFile+=+'D:\somewhere\DB\backup.dat'

--+the+new+database+name
DECLARE+@TestDB+varchar(200)
SET+@TestDB+=+'boon_db'

--+the+new+database+files+without+.mdf/.ldf
DECLARE+@RestoreFile+varchar(2000)
SET+@RestoreFile+=+'D:\somewhere\DB'


--+****************************************************************
--++++++++++++++++++++no+change+below+this+line
--+****************************************************************


DECLARE+@query+varchar(2000)

DECLARE+@DataFile+varchar(2000)
SET+@DataFile+=+@RestoreFile+%2B+'.mdf'

DECLARE+@LogFile+varchar(2000)
SET+@LogFile+=+@RestoreFile+%2B+'.ldf'

IF+@DB+IS+NOT+NULL
BEGIN
++++SET+@query+=+'BACKUP+DATABASE+'+%2B+@DB+%2B+'+TO+DISK+=+'+%2B+QUOTENAME(@BackupFile,+'''')
++++EXEC+(@query)
END

--+RESTORE+FILELISTONLY+FROM+DISK+=+'C:\temp\backup.dat'
--+RESTORE+HEADERONLY+FROM+DISK+=+'C:\temp\backup.dat'
--+RESTORE+LABELONLY+FROM+DISK+=+'C:\temp\backup.dat'
--+RESTORE+VERIFYONLY+FROM+DISK+=+'C:\temp\backup.dat'

IF+EXISTS(SELECT+*+FROM+sysdatabases+WHERE+name+=+@TestDB)
BEGIN
++++SET+@query+=+'DROP+DATABASE+'+%2B+@TestDB
++++EXEC+(@query)
END

RESTORE+HEADERONLY+FROM+DISK+=+@BackupFile
DECLARE+@File+int
SET+@File+=+@@ROWCOUNT

DECLARE+@Data+varchar(500)
DECLARE+@Log+varchar(500)

SET+@query+=+'RESTORE+FILELISTONLY+FROM+DISK+=+'+%2B+QUOTENAME(@BackupFile+,+'''')

CREATE+TABLE+#restoretemp
(
+LogicalName+varchar(500),
+PhysicalName+varchar(500),
+type+varchar(10),
+FilegroupName+varchar(200),
+size+int,
+maxsize+bigint,
+fileid+bigint,
+createlsn+numeric(26),
+droplsn+numeric(26),
+uniqueid+uniqueidentifier,
+readonlylsn+numeric(26),
+readwritelsn+numeric(26),
+BackupSizeInBytes+bigint,
+SourceBlockSize+int,
+FileGroupId+int,
+LogGroupGUID+uniqueidentifier,
+DifferentialBaseLSN+numeric(26),
+DifferentialBaseGUID+uniqueidentifier,
+IsReadOnly+bit,
+IsPresent+bit,
+TDEThumbprint+varbinary(40)
)
INSERT+#restoretemp+EXEC+(@query)

SELECT+@Data+=+LogicalName+FROM+#restoretemp+WHERE+type+=+'D'
SELECT+@Log+=+LogicalName+FROM+#restoretemp+WHERE+type+=+'L'

PRINT+@Data
PRINT+@Log

TRUNCATE+TABLE+#restoretemp
DROP+TABLE+#restoretemp

IF+@File+>+0
BEGIN
++++SET+@query+=+'RESTORE+DATABASE+'+%2B+@TestDB+%2B+'+FROM+DISK+=+'+%2B+QUOTENAME(@BackupFile,+'''')+%2B+
++++++++'+WITH+MOVE+'+%2B+QUOTENAME(@Data,+'''')+%2B+'+TO+'+%2B+QUOTENAME(@DataFile,+'''')+%2B+',+MOVE+'+%2B
++++++++QUOTENAME(@Log,+'''')+%2B+'+TO+'+%2B+QUOTENAME(@LogFile,+'''')+%2B+',+FILE+=+'+%2B+CONVERT(varchar,+@File)
++++EXEC+(@query)
END
GO|1436772|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/443421/sql-2005-quick-way-to-quickly-duplicate-a-database-data/443511#443511^0|0|1N|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|13|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|14|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|15|8|@]|9|@]|C|$]]|$1|O|3|P|5|J|7|16|8|@]|9|@]|C|$K|L]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]]]

the post above <a href="https://stackoverflow.com/questions/443421/sql-2005-quick-way-to-quickly-duplicate-a-database-data/443511#443511">SQL 2005 - quick way to quickly duplicate a database + data</a> works...

but if u r using sql server 2008 r2 for example, u may need a slight mod on the "create table #restoretemp" portion because the return from "restore filelistonly..." has changed since...

basically add this after "maxsize bigint"

<pre><code> maxsize bigint,
 fileid bigint,
 createlsn numeric(26),
 droplsn numeric(26),
 uniqueid uniqueidentifier,
 readonlylsn numeric(26),
 readwritelsn numeric(26),
 BackupSizeInBytes bigint,
 SourceBlockSize int,
 FileGroupId int,
 LogGroupGUID uniqueidentifier,
 DifferentialBaseLSN numeric(26),
 DifferentialBaseGUID uniqueidentifier,
 IsReadOnly bit,
 IsPresent bit,
 TDEThumbprint varbinary(40)
</code></pre>

and u will end up with the working script below... 

<pre><code>USE master
GO

-- the original database (use 'SET @DB = NULL' to disable backup)
DECLARE @DB varchar(200)
SET @DB = 'source_db_name'

-- the backup filename
DECLARE @BackupFile varchar(2000)
SET @BackupFile = 'D:\somewhere\DB\backup.dat'

-- the new database name
DECLARE @TestDB varchar(200)
SET @TestDB = 'boon_db'

-- the new database files without .mdf/.ldf
DECLARE @RestoreFile varchar(2000)
SET @RestoreFile = 'D:\somewhere\DB'


-- ****************************************************************
-- no change below this line
-- ****************************************************************


DECLARE @query varchar(2000)

DECLARE @DataFile varchar(2000)
SET @DataFile = @RestoreFile + '.mdf'

DECLARE @LogFile varchar(2000)
SET @LogFile = @RestoreFile + '.ldf'

IF @DB IS NOT NULL
BEGIN
 SET @query = 'BACKUP DATABASE ' + @DB + ' TO DISK = ' + QUOTENAME(@BackupFile, '''')
 EXEC (@query)
END

-- RESTORE FILELISTONLY FROM DISK = 'C:\temp\backup.dat'
-- RESTORE HEADERONLY FROM DISK = 'C:\temp\backup.dat'
-- RESTORE LABELONLY FROM DISK = 'C:\temp\backup.dat'
-- RESTORE VERIFYONLY FROM DISK = 'C:\temp\backup.dat'

IF EXISTS(SELECT * FROM sysdatabases WHERE name = @TestDB)
BEGIN
 SET @query = 'DROP DATABASE ' + @TestDB
 EXEC (@query)
END

RESTORE HEADERONLY FROM DISK = @BackupFile
DECLARE @File int
SET @File = @@ROWCOUNT

DECLARE @Data varchar(500)
DECLARE @Log varchar(500)

SET @query = 'RESTORE FILELISTONLY FROM DISK = ' + QUOTENAME(@BackupFile , '''')

CREATE TABLE #restoretemp
(
 LogicalName varchar(500),
 PhysicalName varchar(500),
 type varchar(10),
 FilegroupName varchar(200),
 size int,
 maxsize bigint,
 fileid bigint,
 createlsn numeric(26),
 droplsn numeric(26),
 uniqueid uniqueidentifier,
 readonlylsn numeric(26),
 readwritelsn numeric(26),
 BackupSizeInBytes bigint,
 SourceBlockSize int,
 FileGroupId int,
 LogGroupGUID uniqueidentifier,
 DifferentialBaseLSN numeric(26),
 DifferentialBaseGUID uniqueidentifier,
 IsReadOnly bit,
 IsPresent bit,
 TDEThumbprint varbinary(40)
)
INSERT #restoretemp EXEC (@query)

SELECT @Data = LogicalName FROM #restoretemp WHERE type = 'D'
SELECT @Log = LogicalName FROM #restoretemp WHERE type = 'L'

PRINT @Data
PRINT @Log

TRUNCATE TABLE #restoretemp
DROP TABLE #restoretemp

IF @File &gt; 0
BEGIN
 SET @query = 'RESTORE DATABASE ' + @TestDB + ' FROM DISK = ' + QUOTENAME(@BackupFile, '''') + 
 ' WITH MOVE ' + QUOTENAME(@Data, '''') + ' TO ' + QUOTENAME(@DataFile, '''') + ', MOVE ' +
 QUOTENAME(@Log, '''') + ' TO ' + QUOTENAME(@LogFile, '''') + ', FILE = ' + CONVERT(varchar, @File)
 EXEC (@query)
END
GO
</code></pre>

I have my development database, I want to spin off a duplicate for testing. I want to do this often.

What's the fastest and easiest way to do this often? I can get the job done by generating scripts w/ data included but I feel like there must be a better way. Should I back up database 1 then screw around with it so I can restore it as a different name?

SQL 2005 - quick way to quickly duplicate a database + data

我有我的开发数据库，我想旋转一个副本进行测试。我想经常这样做。经常这样做的最快、最简单的方法是什么？我可以通过生成包含数据的脚本来完成这项工作，但我觉得肯定有更好的方法。我是否应该备份数据库1，然后再修改它，这样我就可以将它恢复为不同的名称？

问SQL 2005 -快速复制数据库+数据的快速方法
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL 2005 -快速复制数据库+数据的快速方法EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL 2005 -快速复制数据库+数据的快速方法
EN