"The requested operation could not be completed due to a file system limitation" 3202

Posted by user46529 on Server Fault See other posts from Server Fault or by user46529
Published on 2010-12-20T21:38:28Z Indexed on 2010/12/22 22:55 UTC
Read the original article Hit count: 202

Filed under:
|

I backup SQL Server database and it fails

BACKUP DATABASE dd TO
DISK = '\backupServer\backups\dd.bak' WITH
COMPRESSION,
CHECKSUM,
NOFORMAT, INIT , BlockSize = 65536 , BufferCount = 2200 , MaxTransferSize = 4194304

The backup size is 3TB and I have 6TB free space on bacup server. I am using backup parameters per SQLCAT whitepaper.

Everything works ok when I backup to local HDD and it always fails when I backup to network share. After about 6 hours. Can't find why.

Thank you.

Yes. The backup over the network is fastest and saves me 3Tb of local disk space :) Thanks for pointing to the memory issue. I left 4Gb to OS and it worked!

© Server Fault or respective owner

Related posts about sql-server

Related posts about backup