解决阻止数据库备份的 665 错误
尝试备份数据库时，失败率达到 30%。我尝试对磁盘进行碎片整理来解决问题，但在同一步骤中仍然失败。我想了解为什么它失败了。
服务器“Servernamehere”的备份失败。 (Microsoft.SqlServer.SmoExtended)
附加信息：
System.Data.SqlClient.SqlError：写入“E:\Microsoft SQL 服务器\MSAS10.MSSQLSERVER\Backup\FrameProcess\FrameProcess.bak” 失败：665（由于某个原因，请求的操作无法完成 文件系统限制）(Microsoft.SqlServer.Smo)
When trying to do a back up of a database it fails at 30 percent. I try to defrag the disk to solve the problem but it still fails in the same step. I would like to understand why it failed.
Backup failed for Server 'Servernamehere'. (Microsoft.SqlServer.SmoExtended)
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Write on "E:\Microsoft SQL
Server\MSAS10.MSSQLSERVER\Backup\FrameProcess\FrameProcess.bak"
failed: 665(The requested operation could not be completed due to a
file system limitation) (Microsoft.SqlServer.Smo)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
我们遇到了同样的问题：备份失败，错误消息为 665。
原因是磁盘碎片过多。
请参阅：
http://support.microsoft.com/kb/2002606
我们在所有磁盘上运行 Windows Defrag这解决了它。
We had the same problem: backup fails with error message 665.
The cause was excesive disk fragmentation.
Please see:
http://support.microsoft.com/kb/2002606
We run Windows Defrag on all the disks and that fixed it.
导致此错误的原因之一可能是使用文件夹压缩。如果您正在使用它，请尝试备份到非压缩文件夹。
One cause of this error can be using folder compression. If you are using it, try backing up to a non-compressed folder instead.
你看过这个吗？ http://support.microsoft.com/default.aspx?scid =kb;EN-US;957065
您没有指定操作系统，但症状听起来很相似。
Have you taken a look at this? http://support.microsoft.com/default.aspx?scid=kb;EN-US;957065
You don't specify the OS, but the symptoms sound similar.
您能否在磁盘级别检查一下：-
任何碎片和收缩都按所需的时间间隔运行。如果是，请将其禁用以解决问题。如果不能，请要求服务器团队来完成。
我遇到了同样的问题，禁用磁盘后解决了。
Could you please check that on disk level:-
Any fragmentation and Shrinking is running on required interval. If yes, disable it to resolve the issue. Ask the Server team to do it if you can't.
I had same issue and its got resolved after disabling the disk.
我能够通过在备份中指定多个文件而不是一个大文件来解决此错误。整个备份大约有 60GB，我将其分成 12 个 5GB 文件，错误就消失了。
后来，我检查了该特定磁盘的碎片级别，结果显示碎片约为 40%。正如之前的答案中所述，这可能是相关的。
I was able to get around this error by specifying multiple files in the backup instead of one big file. The whole backup is around 60GB, I split it into 12 5GB files and the error went away.
Later on, I checked the fragmentation level for that particular disk and it was showing around 40% fragmentation. It might be related as stated in previous answers.