无法复制一些SQL服务器文件 [英] Can not copy some SQL server files

问题描述

我已将几个数据库附加到我的sql server实例。我想知道不同的行为，而DB已经以相同的方式附加。



当我尝试复制包含文件的文件夹时，一些文件不会复制和给出错误，该文件正在使用中，而另一些，附加到同一实例和同一文件夹中，复制没有任何问题。

请告知有什么区别？



谢谢

Hi,
I have attached a few databases to my sql server instance. I wonder about the different behavious, while DBs have been attached the same way.

When I try to copy the folder that contains the files, some files do not copy and give error that file is in use, while some other, attached to the same instance and in the same folder, copy without any problem.
Please advise what is the difference?

Thanks

推荐答案

如果要复制mdf和ldf等文件，可能需要在复制之前停止SQL Server服务。



否则备份数据库并复制它！

If you want to copy files like mdf & ldf, you may need to stop SQL Server services before copying it.

Else take backup of the database and copy it!

这篇关于无法复制一些SQL服务器文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！