A scheduled transaction log backup failed.
I scripted the failing statement and re-ran the command in SSMS (this is a dev server). The command:
BACKUP LOG [GLPart] TO DISK = N’T:\SQBACK\Default\GLPart_backup_2012_08_30_111114_9999915.trn’ WITH NOFORMAT, NOINIT, NAME = N’GLPart_backup_2012_08_30_111114_9999915′, SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10
failed with the following error message:
Processed 1 pages for database ‘GLPart’, file ‘GLPart_log’ on file 1.
Msg 3634, Level 16, State 1, Line 1
The operating system returned the error ‘112(There is not enough space on the disk.)’ while attempting ‘FsLogMgr::LogInternal:CreateFile’ on ‘\\?\T:\GLPart\FSG1\FSG1\$FSLOG\ffffffde-fffff2dd-fffa.00000021-00000d22-0005.a60507ca-2e5d-4f21-a94f-ca115c2f32ff.0-0.1000016’.
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
—————–
Resolution
The volume holding the filestream part of the database had filled up – 0% free. I removed some redundant files and re-ran. This now succeeded. The error message referred to space on the disk holding my filestream data.
Discussion
No comments yet.