blocks|key|199683|text|在恢复时，您需要确保|type|unstyled|depth|inlineStyleRanges|entityRanges|data|199684|199685|选择一个不存在新数据库名称(除非您想覆盖已存在的数据库)|unordered-list-item|199686|199687|​|199688|📷|atomic|offset|length|199689|199690|199691|勾选Options选项卡页中的Overwrite选项，并为.mdf和.ldf文件定义有效的和新文件名，这样就不会意外覆盖系统上的另一个数据库：|style|CODE|199692|199693|199694|199695|199696|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/e6b1884c921b188db008d304dba0065f.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/7a0f2951826b899f41115cb3c69debd0.png^0|0|0|0|0|0|0|1|0|0|0|0|2|7|F|9|T|4|Y|4|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1A|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|1C|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|1D|8|@]|9|@$L|1E|M|1F|1|1G]]|A|$]]|$1|N|3|H|5|6|7|1H|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|P|3|Q|5|E|7|1J|8|@$L|1K|M|1L|R|S]|$L|1M|M|1N|R|S]|$L|1O|M|1P|R|S]|$L|1Q|M|1R|R|S]]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|U|3|H|5|6|7|1T|8|@]|9|@]|A|$]]|$1|V|3|J|5|K|7|1U|8|@]|9|@$L|1V|M|1W|1|1X]]|A|$]]|$1|W|3|H|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|14|15|-4]]|16|$5|10|11|12|A|$13|17|15|-4]]]]

When restoring, you need to be sure to

<ul>
<li>pick a new database name that doesn't already exist (unless you want to overwrite that pre-existing database)</li>
</ul>

<img src="https://i.stack.imgur.com/7bgDO.png" alt="enter image description here">

<ul>
<li>you tick the <code>Overwrite</code> option in the <code>Options</code> tab page and define valid and new file names for the <code>.mdf</code> and <code>.ldf</code> file so that you don't accidentally overwrite another database on your system:</li>
</ul>

<img src="https://i.stack.imgur.com/SiGhA.png" alt="enter image description here">

blocks|key|197143|text|这篇文章有一些很好的答案，但我不相信我的解决方案在这里被涵盖，或者我不理解答案/评论。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|197144|但是，当我遇到此错误时，我正在恢复具有2个索引(主索引和索引)的数据库。问题是，在恢复时，它创建了两个.ndf文件，每个文件对应一个索引，但命名相同。|197145|所以基本上我有两个“恢复为”文件恢复到"D:\MSSQLDATA\DatabaseName.ndf“。|197146|为了克服这个问题，我必须更改其中一个文件名，例如，我更改了|197147|+Index++++++%7C++++D:\MSSQLDATA\DatabaseName.ndf
+Primary++++%7C++++D:\MSSQLDATA\DatabaseName1.ndf|code-block|syntax|javascript|197148|具有唯一的文件名为我解决了这个问题。|197149|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|U|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

This post has some excellent answers but I don't believe my solution was covered here, or I didn't understand the answer/comment. 

However, when I encountered this error I was restoring a database with 2 indexes (Primary and Index). The issue was that when restoring it had created two .ndf files, one for each index, but had named them the same thing. 

So essentially I had two "Restore As" files restoring to "D:\MSSQLDATA\DatabaseName.ndf. 

To overcome this I had to change one of the file names, so for example I changed

<pre><code> Index | D:\MSSQLDATA\DatabaseName.ndf
 Primary | D:\MSSQLDATA\DatabaseName1.ndf
</code></pre>

having unique file names fixed this for me.

blocks|key|197820|text|这对我很有效:在脚本部分为每个MDF和LDF文件指定一个不同的名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|197821|MOVE+N'R_Data'+
++TO+N'C:\Program+Files\Microsoft+SQL+Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Build51_Testing_db1.mdf',

MOVE+N'R_audit'+
++TO+N'C:\Program+Files\Microsoft+SQL+Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Build51_Testing_db2.mdf',+|code-block|syntax|javascript|197822|等等。|197823|最初是由Alberto+Morillo提出的|197824|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

This worked for me : giving a different name to each MDF and LDF file in the script section.

<pre><code>MOVE N'R_Data' 
 TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Build51_Testing_db1.mdf',

MOVE N'R_audit' 
 TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Build51_Testing_db2.mdf', 
</code></pre>

etc...

Originally suggested by Alberto Morillo

blocks|key|3038008|text|我知道距离上一个答案已经很久了，但我碰巧在谷歌上搜索了这个问题的解决方案。为我做的是编写恢复脚本(更改文件名不起作用)和手动更改代码中的文件名|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3038009|RESTORE+DATABASE+[DB_NAME]+
FILE+=+N'[name]',++
FILE+=+N'[name1]',
FILE+=+N'[name2]'+
FROM++DISK+=+N'[file_path]'+
WITH++FILE+=+1m
MOVE+N'[name]'+TO+N'D:\Program+Files\Microsoft+SQL+Server\MSSQL11.MSSQLSERVER\MSSQL\Data\\[name].mdf',
MOVE+N'[name1]'+TO+N'D:\Program+Files\Microsoft+SQL+Server\MSSQL11.MSSQLSERVER\MSSQL\Data\\[name1].mdf',
MOVE+N'[name2]'+TO+N'D:\Program+Files\Microsoft+SQL+Server\MSSQL11.MSSQLSERVER\MSSQL\Data\\[name2].mdf',
MOVE+N'[logname]'+TO+N'D:\Program+Files\Microsoft+SQL+Server\MSSQL11.MSSQLSERVER\MSSQL\Data\\[logname].ldf'
NOUNLOAD,
REPLACE,
STATS+=+10
GO|code-block|syntax|javascript|3038010|问候|3038011|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I know it's long since the last answer, but I happened to search in google for solution for this problem.
What did it for me, was scripting the restore (changing file name did not do the trick) and manually changing the filenames in code

<pre><code>RESTORE DATABASE [DB_NAME] 
FILE = N'[name]', 
FILE = N'[name1]',
FILE = N'[name2]' 
FROM DISK = N'[file_path]' 
WITH FILE = 1m
MOVE N'[name]' TO N'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\\[name].mdf',
MOVE N'[name1]' TO N'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\\[name1].mdf',
MOVE N'[name2]' TO N'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\\[name2].mdf',
MOVE N'[logname]' TO N'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\\[logname].ldf'
NOUNLOAD,
REPLACE,
STATS = 10
GO
</code></pre>

Regards

blocks|key|199746|text|如果您有此问题，但不是上面的问题，请在Restore+Options+>+Files下尝试，选中Relocate+all+files+to+folder复选框。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|199747|​|199748|📷|atomic|offset|length|199749|199750|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/17f23877b903d0343d4251e532a04415.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

If you have this issue and it's not the above, try under the Restore Options > Files, check the Relocate all files to folder checkbox.

<img src="https://i.stack.imgur.com/PiTDg.png" alt="enter image description here">

blocks|key|2825236|text|在我的例子中，在我的\DATA文件夹中已经有一个.mdf和.ldf文件，所以我必须创建两个新文件：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2825237|New-Item+C:\path\to\sql\DATA\NewDatabase.mdf
New-Item+C:\path\to\sql\DATA\NewDatabase_log.ldf|code-block|syntax|javascript|2825238|然后在SQL管理器中，您需要在恢复数据库时选择这些新文件。|2825239|entityMap^0|A|5|O|4|T|4|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

In my case, there was already a <code>.mdf</code> and <code>.ldf</code> file in my <code>\DATA</code> folder, so I had to create two new files:

<pre><code>New-Item C:\path\to\sql\DATA\NewDatabase.mdf
New-Item C:\path\to\sql\DATA\NewDatabase_log.ldf
</code></pre>

And then in the SQL manager you need to select those new files when restoring the database.

blocks|key|3038108|text|在我的例子中，数据库有2个mdf文件。错误出现了，因为我正在尝试将两个mdf文件恢复为相同的名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3038109|只需将第二个mdf文件重命名为"Restore+As“。|3038110|​|3038111|📷|atomic|offset|length|3038112|3038113|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/a293cae0cae2dc0d70ad3fd9de40b6c7.png|imageAlt^0|0|0|0|0|1|0|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|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

In my case, the database has 2 mdf files. And the error came, because I'm trying to restore both mdf files as the same name.
Just rename the second mdf file, under &quot;Restore As&quot;.
<a href="https://i.stack.imgur.com/5QX7U.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5QX7U.png" alt="enter image description here" /></a>

I am trying to restore a database backup but getting error:

<blockquote>
 Restore failed for Server 'ASIF-VAIO'. 
 (Microsoft.SqlServer.SmoExtended)
 
 ADDITIONAL INFORMATION:
 
 System.Data.SqlClient.SqlError: File 'C:\Program Files\Microsoft SQL
 Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\uwa.mdf' is claimed by
 'Aston_Fresh_log'(2) and 'Aston_Fresh'(1). The WITH MOVE clause can be
 used to relocate one or more files. (Microsoft.SqlServer.Smo)
</blockquote>

database restore failing with move

SQL Server

数据库

服务器

我正在尝试恢复数据库备份，但遇到错误：服务器'ASIF-VAIO‘的恢复失败。(Microsoft.SqlServer.SmoExtended)其他信息：System.Data.SqlClient.SqlError:文件'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\uwa.mdf‘由'Aston_F

问数据库还原因移动而失败
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数据库还原因移动而失败EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数据库还原因移动而失败
EN