By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

failed backup and got error 112

P: 4
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
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
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

P: 8
This error is due to low disk space.Clear the space and take the backup
Dec 18 '08 #3

ck9663
Expert 2.5K+
P: 2,878
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.