failed backup and got error 112

nic829

Hi,

I was trying to back up a database on SQL 2005 SP2 but then got this error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Backup failed for Server 'NTSYDDBD155\MMSGDEV02'. (Microsoft.SqlServer.Smo)
For help, click: <http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Backup+Server&LinkId=20476>
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Write on "D:\SQLBackups\ScheduledBackups\MMSGDEV02\CRD. bak" failed: 112(error not found) (Microsoft.SqlServer.Smo)
For help, click: <http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&LinkId=20476>
------------------------------

Other databases on the server can backup successfully. Any clue?

Many Thanks,
Nicole

Oct 22 '08 #1

ck9663

Strange, even Microsoft don't have any other info.

Try backing it up manually and see if there are errors.

Keep us posted.

-- CK

Oct 22 '08 #2

madan agarwal

This error is due to low disk space.Clear the space and take the backup

Dec 18 '08 #3

ck9663

You might need to overwrite everything, You don't really know what is written and how SQL Server splits information and which part is written on which primary file. Backup all primary files you have, detached the database, restore the first corrupted file and see what happens.

Backup everything first.

-- CK

Dec 18 '08 #4