//
you're reading...
2012

error ‘112(There is not enough space on the disk.)’ while attempting ‘FsLogMgr::LogInternal:CreateFile’

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.

About iantreasure

DBA with 25 years experience (SQL Server, Oracle).

Discussion

No comments yet.

Leave a comment