Backup and got error 112

Question

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&EvtID=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, just 2 of them got this error. Any clue?

 

Many Thanks,

Nicole

Answer 1

Is there sufficient space in the disk for the backup to get completed ? Please check the error log as well for any clues..

- Deepak

Answer 2

 

Looks like a file path issue.

 

MMSGDEV02\CRD looks like an named instance, but the "\" character adds to the directory path.  Try changing the "\" to a "-" before starting the backup.  You may need to generate a script from SSMS and hand-edit it.