Sql-server – getting through 665 Error that prevents database backup

event-logsql serversql-server-2008

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)

Best Answer

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.

Related Solutions

Sql-server – SQL Server Restore Error – Access is Denied

I have just had this issue with SQL Server 2012.

It turns out all I had to do was tick the box marked 'Relocate all files to folder' on the 'Files' section:

(Click to see image full size)

This of course assumes you have the correct version of SQL Server installed.

Sql-server – Error restoring database backup

Sounds like the backup was taken on a machine whose paths do not match yours. Try performing the backup using T-SQL instead of the UI. Also make sure that the paths you're specifying actually exist and that there isn't already a copy of these mdf/ldf files in there.

RESTORE DATABASE MYDB_ABC FROM DISK = 'C:\path\file.bak'
WITH MOVE 'mydb' TO 'c:\valid_data_path\MYDB_ABC.mdf',
MOVE 'mydb_log' TO 'c:\valid_log_path\MYDB_ABC.ldf';

Best Answer

Related Solutions

Sql-server – SQL Server Restore Error – Access is Denied

Sql-server – Error restoring database backup

Related Topic