Failed database back-up

Question

Failed database back-up

I get the following error message in my maintenainceplan history. Unfortunately I do not have much knowledge of SQL and I would like to ask if someone can further help me.

(Maintenance Plan has been working well for months.)

Type: SQL cluster (version SQl Server 2008 R2)

Taskdetail: Databases: **,**,**,**,**,**,**,**,**,**,**
Type: Full
Append existing

Error number: -1073548784

Error message:
Executing the query "BACKUP DATABASE [LogisP] TO  DISK = N'\\\\****\\s..." failed with the following error: "A nonrecoverable I/O error occurred on file "

\\\\******\\sql\\SQLCLU04\\****_backup_2013_05_29_050502_3909779.bak:

" 112(failed to retrieve text for this error. Reason: 15105).

BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Answer 1

\\\\******\\sql\\SQLCLU04\\****_backup_2013_05_29_050502_3909779.bak:

" 112(failed to retrieve text for this error. Reason: 15105).

Hello

System error 112 ERROR_DISK_FULL = There is not enough space on the disk.

---

Olaf Helper

Blog Xing

Answer 2

Thanks for the comments!

It was indeed insufficient disk space during the backup process. I am now using perfmon to figure out how much disk space disk space needed during the backup process. minimum free

Answer 3

Is there away to calculatethisIn sql? i heard something about "sp-helpdb"

Answer 4

Hello,

You could use sp_helpdb but I tend to stay away from the built in stored proceudres as they return multiple result sets that make it hard to use programmatically.

You could get a list of data files through sys.master_files and then sum their space used with FILEPROPERTY (which is in pages allocated FYI) to get a fairly close estimate.

http://msdn.microsoft.com/en-us/library/ms188401.aspx

-Sean

---

Sean Gallardy | Blog | Twitter