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\MM SGDEV02'. (Microsoft.SqlS erver.Smo)
For help, click: <http://go.microsoft.co m/fwlink?ProdName =Microsoft+SQL+ Server&ProdVer= 9.00.3042.00&Ev tSrc=Microsoft. SqlServer.Manag ement.Smo.Excep tionTemplates.F ailedOperationE xceptionText&Ev tID=Backup+Serv er&LinkId=20476 >
------------------------------
ADDITIONAL INFORMATION:
System.Data.Sql Client.SqlError : Write on "D:\SQLBackups\ ScheduledBackup s\MMSGDEV02\CRD .bak" failed: 112(error not found) (Microsoft.SqlS erver.Smo)
For help, click: <http://go.microsoft.co m/fwlink?ProdName =Microsoft+SQL+ Server&ProdVer= 9.00.3042.00&Li nkId=20476>
------------------------------

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

Many Thanks,
Nicole

[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

[madan agarwal]

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

[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