While running backup of 4 TB database on Local C drive where
available space is around 1.5 TB on SQL server 2008 R2 EE backup command failed
with some error. But the error did not
depict the insufficient disk space.
After modifying the command with backup compression option completed successfully.
BACKUP DATABASE [GoogleAnalytics]
TO DISK = 'C:\GA-DB-Backup\GoogleAnalytics_06122012.BAK'
WITH INIT,STATS = 10
Error message
Msg 3271, Level 16,
State 1, Line 1
A nonrecoverable
I/O error occurred on file
"C:\GA-DB-Backup\GoogleAnalytics_06122012.BAK:" 112(failed to
retrieve text for this error. Reason: 15105).
Msg 3013, Level 16,
State 1, Line 1
BACKUP DATABASE is
terminating abnormally.
So you should
not panic, first need to check disk space whether is sufficient to take backup
of database based on the size.
No comments:
Post a Comment