0

I am running a split disk backup such as: 

BACKUP DATABASE [At] TO  
DISK = N'O:\sql_bak\At_full1.bak',  
DISK = N'M:\sql_bak\At_full2.bak',
DISK = N'L:\sql_bak\At_full3.bak' WITH NOFORMAT, 
INIT,  
NAME = N'At-Full Database Backup', 
SKIP, 
NOREWIND, 
NOUNLOAD,  
STATS = 10
GO

It is failing with the below error:

Executed as user: DOMAIN\sqlserviceaccount. Processed 257856 pages for database 'At', file 'At' on file 1. [SQLSTATE 01000] (Message 4035) 10 percent processed. [SQLSTATE 01000] (Message 3211) 20 percent processed. [SQLSTATE 01000] (Message 3211) 30 percent processed. [SQLSTATE 01000] (Message 3211) 40 percent processed. [SQLSTATE 01000] (Message 3211) 50 percent processed. [SQLSTATE 01000] (Message 3211) 60 percent processed. [SQLSTATE 01000] (Message 3211) 70 percent processed. [SQLSTATE 01000] (Message 3211) 80 percent processed. [SQLSTATE 01000] (Message 3211) Write on "O:\sql_bak\At_full1.bak" failed: 112(There is not enough space on the disk.) [SQLSTATE 42000] (Error 3202) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

The database At is of 4TB size and the drives L,M and O are of 2TB each. These drives are completely free. It ran successfully once and since then it has been failing. Please suggest.

Anandita Sharma
  • 405
  • 1
  • 3
  • 9
  • "Drives L, M, and O are 2TB each". Is that total capacity per drive? Or free space per drive? – Dave Mason Mar 24 '15 at 12:57
  • @DMason The drives L, M and O have total capacity = 2TB each and as these are totally free, we have free space = 2TB on each drive. – Anandita Sharma Mar 24 '15 at 13:01
  • I know this doesn't answer your question (and it is quite interesting), but have you tried using `WITH COMPRESSION`? – Dave Mason Mar 24 '15 at 18:06
  • [Trace flag 3042](https://msdn.microsoft.com/en-us/library/ms188396(v=sql.110).aspx) might help you also. – Dave Mason Mar 24 '15 at 19:39
  • @DMason the backup was successful after I added the WITH COMPRESSION option. Thanks. But I feel it is just a workaround and not a permanent fix because I am not sure if the backup will succeed once the database size has increased further. What do you think? – Anandita Sharma Mar 25 '15 at 10:17
  • Yes, I also consider it a workaround. The issue warrants further research. Have you tried trace flag 3042? I'd be interested to hear your results. Keep us posted! – Dave Mason Mar 25 '15 at 13:10

0 Answers0