467,917 Members | 1,358 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

failed backup and got error 112

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
  • viewed: 12612
Share:
3 Replies
ck9663
Expert 2GB
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
This error is due to low disk space.Clear the space and take the backup
Dec 18 '08 #3
ck9663
Expert 2GB
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

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Teggaman | last post: by
5 posts views Thread by TThai | last post: by
9 posts views Thread by Trevor Best | last post: by
3 posts views Thread by Microsoft | last post: by
1 post views Thread by edmundleungs | last post: by
3 posts views Thread by xeqister | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.