Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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!

share|improve this question
1  
Have you tried performing a local backup and then doing a manual copy over to your network share? Might help eliminate something. –  ErnieTheGeek Dec 20 '10 at 21:50

1 Answer 1

up vote 1 down vote accepted

Backing up large databases over the network is not recommended. This will steal all the memory from the database engine and give it to the system cache.

share|improve this answer
    
I concur with Denny. The error that you are receiving is because of the file system format of the network share. Please take the backup locally and move it to the network share using tools like ROBOCOPY. It helps in many ways –  Pradeep Adiga Dec 21 '10 at 4:16
    
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! –  user46529 Dec 22 '10 at 22:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.