blocks|key|1321850|text|可能会是这样的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1321851|RESTORE+DATABASE+[NewDB]+
++++FROM++DISK+=+N'Path\file.bak'+
++++WITH++FILE+=+1,++
++++MOVE+N'NewDB_Data'+TO+N'C:\Data\MSSQL.1\MSSQL\Data\NewDB_Data.mdf',++
++++MOVE+N'NewDB_Log'+TO+N'C:\Data\MSSQL.1\MSSQL\Data\NewDB_Log.ldf',++
++++NOUNLOAD,++STATS+=+10|code-block|syntax|javascript|1321852|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

May be it will be something like this:

<pre><code>RESTORE DATABASE [NewDB] 
 FROM DISK = N'Path\file.bak' 
 WITH FILE = 1, 
 MOVE N'NewDB_Data' TO N'C:\Data\MSSQL.1\MSSQL\Data\NewDB_Data.mdf', 
 MOVE N'NewDB_Log' TO N'C:\Data\MSSQL.1\MSSQL\Data\NewDB_Log.ldf', 
 NOUNLOAD, STATS = 10
</code></pre>

blocks|key|1326060|text|如果你是新手，最简单的方法就是|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1326061|a)在SQL+Management+Studio中创建一个数据库，但不要单击"OK“来创建它，而是将该操作编写为SQL脚本并运行它。|1326062|b)在management+studio中恢复.bak文件，确保备份文件位置指向正确的位置，并再次编写操作脚本，而不是单击确定。|1326063|c)将两个文件合并为1，得到一个“克隆数据库”sql脚本。|1326064|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Easiest way if you are new to this I would say is to

a) Create a database in SQL Management Studio but instead of clicking "OK" to create it, script out the action as an SQL script and run it.

b) Restore the .bak file in management studio making sure you get the backup file locations pointing in the correct place and again script out the action instead of clicking OK.

c) Merge two files into 1 to give you a "clone database" sql script.

blocks|key|578578|text|是的，您可以使用备份作为克隆数据库的一种方法。为此，您可以简单地使用RESTORE命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|578579|例如：|578580|RESTORE+DATABASE++++DatabaseName
FROM+DISK+=+N'C:\Path\To\Your\File.bak'|code-block|syntax|javascript|578581|有关RESTORE命令参数的更多参考，请查看MSDN参考资料：Click!|offset|length|578582|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms186858.aspx^0|0|0|0|V|6|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

Yes, you can use backup as a method of cloning a database. For this, you can simply use the RESTORE command.

For example:

<pre><code>RESTORE DATABASE DatabaseName
FROM DISK = N'C:\Path\To\Your\File.bak'
</code></pre>

For further reference about parameters for the RESTORE command, have a look at the MSDN reference for it: <a href="http://msdn.microsoft.com/en-us/library/ms186858.aspx" rel="nofollow noreferrer">Click!</a>

blocks|key|2119807|text|使用c#.net实现你想要的功能这里是关于创建应用程序来备份和恢复数据库的文章的一行：http://www.geekpedia.com/tutorial180_Backup-and-restore-SQL-databases.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2119808|entityMap|0|LINK|mutability|MUTABLE|url|http://www.geekpedia.com/tutorial180_Backup-and-restore-SQL-databases.html^0|17|22|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Use c#.net to achieve functionality you want here is line of the article which talks about creating application to back and restore database : <a href="http://www.geekpedia.com/tutorial180_Backup-and-restore-SQL-databases.html" rel="nofollow noreferrer">http://www.geekpedia.com/tutorial180_Backup-and-restore-SQL-databases.html</a>

blocks|key|1326114|text|我们使用SQL+Server+2005，并且出于测试目的不断地复制和交换数据库。我们现在总是使用备份和还原。分离和重新附加.mdf和.ldf文件经常会导致SQL+Server损坏到需要重新安装的地步，甚至可能在此之前进行非常丑陋的清理。正如其他几个人所建议的那样，使用.bak文件非常简单。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1326115|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|$]]

We use SQL Server 2005 and are continually copying and swapping databases for testing purposes. We ALWAYS now use backup and restore. Detaching, reattaching .mdf and .ldf files has very frequently caused SQL Server to become corrupt to the point of requiring re-installation, and a very ugly cleanup before that is even possible. As several others have suggested, using a .bak file is pretty straightforward.

blocks|key|578628|text|如前所述，您可以使用backup执行此操作。但是，还没有人提到在执行这些临时备份时使用COPY+ONLY选项很重要，以避免考虑您的主备份|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|578629|BACKUP+DATABASE+YourDB
TO+DISK+=+'C:\Backups\YourDB.bak'
WITH+COPY_ONLY;+|code-block|syntax|javascript|578630|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms191495.aspx^0|17|9|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

You can do this with backup as already answered. No one has mentioned yet though that it is important to use the <a href="http://msdn.microsoft.com/en-us/library/ms191495.aspx" rel="nofollow noreferrer">COPY ONLY</a> option when doing these ad hoc backups to avoid mullering your main backups 

<pre><code>BACKUP DATABASE YourDB
TO DISK = 'C:\Backups\YourDB.bak'
WITH COPY_ONLY; 
</code></pre>

blocks|key|3527647|text|为了扩展Maximilian的回答，我建议使用MSBuild和MSBuild+Community+Tasks库的ExecuteDDL任务来自动化这个过程。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3527648|您可以从如下所示的SQL脚本(可能名为CloneDb.sql)开始：|3527649|USE+master
GO

RESTORE+DATABASE+dbname
+++FROM+DISK+=+'SOURCEDIR\dbname.bak'
+++WITH+REPLACE,+FILE+=+1,++
++++MOVE+N'dbname'+TO+N'DBDEVICEDIR\dbname.mdf',++
++++MOVE+N'dbname_log'+TO+N'DBDEVICEDIR\dbname_log.LDF',++
++++NOUNLOAD,++
++++STATS+=+10
GO|code-block|syntax|javascript|3527650|在MSBuild脚本中，您将创建一个包含如下序列的目标：|3527651|<FileUpdate+Files="$(BuildDir)\CloneDb.sql"
++++++++++++++++Regex="SOURCEDIR"
++++++++++++++++ReplacementText="$(SqlSafeActualBuildDir)\dbdeploy"+/>
++++<FileUpdate+Files="$(BuildDir)\CloneDb.sql"
++++++++++++++++Regex="DBDEVICEDIR"
++++++++++++++++ReplacementText="$(SqlSafeActualBuildDir)\dbdevices"+/>
++++<ExecuteDDL+Files="$(BuildDir)\CloneDb.sql"+ConnectionString="Server=$(LocalDbServer);Database=master;Trusted_Connection=True;"+/>|3527652|准备就绪后，从Visual+Studio命令行运行"msbuild.exe+CloneDb.proj+/t:“将在一个步骤中克隆您的数据库。为了方便起见，您可以将命令放在批处理文件中。|3527653|我为我当前的项目创建了一个更复杂的版本，一个由十几个开发人员组成的团队使用它来创建数据库的本地版本，我们的项目使用它来满足他们自己的开发需求。|3527654|entityMap|0|LINK|mutability|MUTABLE|url|http://msbuildtasks.tigris.org/^0|V|N|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|6|7|14|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|15|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|16|8|@]|9|@]|C|$]]|$1|M|3|N|5|H|7|17|8|@]|9|@]|C|$I|J]]|$1|O|3|P|5|6|7|18|8|@]|9|@]|C|$]]|$1|Q|3|R|5|6|7|19|8|@]|9|@]|C|$]]|$1|S|3|-4|5|6|7|1A|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]]]

To extend on Maximilian Mayerl's answer, I would recommend using MSBuild and the ExecuteDDL task of the <a href="http://msbuildtasks.tigris.org/" rel="nofollow noreferrer">MSBuild Community Tasks</a> library to automate this process.

You would start with a SQL script like this one (perhaps called CloneDb.sql):

<pre><code>USE master
GO

RESTORE DATABASE dbname
 FROM DISK = 'SOURCEDIR\dbname.bak'
 WITH REPLACE, FILE = 1, 
 MOVE N'dbname' TO N'DBDEVICEDIR\dbname.mdf', 
 MOVE N'dbname_log' TO N'DBDEVICEDIR\dbname_log.LDF', 
 NOUNLOAD, 
 STATS = 10
GO
</code></pre>

In the MSBuild script, you'd create a target that includes a sequence like this:

<pre><code>&lt;FileUpdate Files="$(BuildDir)\CloneDb.sql"
 Regex="SOURCEDIR"
 ReplacementText="$(SqlSafeActualBuildDir)\dbdeploy" /&gt;
 &lt;FileUpdate Files="$(BuildDir)\CloneDb.sql"
 Regex="DBDEVICEDIR"
 ReplacementText="$(SqlSafeActualBuildDir)\dbdevices" /&gt;
 &lt;ExecuteDDL Files="$(BuildDir)\CloneDb.sql" ConnectionString="Server=$(LocalDbServer);Database=master;Trusted_Connection=True;" /&gt;
</code></pre>

With this in place, running "msbuild.exe CloneDb.proj /t:" from a Visual Studio command-line will clone your database in one step. You can put the command in a batch file for convenience.

I created a more elaborate version of this for my current project, where a team of over a dozen developers uses it to create local versions of the databases our project uses for their own development needs.

I need to write a tool to clone a database, instead of detaching it and copying the .mdf and .ldf, wouldn't it be better to just back it up and restore a newly created db?

Is there a way using SQL to create a database from a .bak?

cloning a database with backing up possible?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我需要写一个工具来克隆数据库，而不是分离它并复制.mdf和.ldf，只备份它并恢复一个新创建的db不是更好吗？有没有一种使用SQL从.bak创建数据库的方法？

问克隆数据库和备份是可能的吗？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问克隆数据库和备份是可能的吗？EN