Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nic829
Starting Member
3 Posts |
 Posted - 2008-10-22 : 05:54:45
|
| 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. Any clue?Many Thanks,Nicole |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-22 : 08:45:27
|
| Error 112 occurs when there is not enough disk space for database backup. |
 |
|
|
|
|
|
backup failed and got error 112