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 |
|
YogeshDesai
Posting Yak Master
136 Posts |
 Posted - 2007-10-05 : 06:36:45
|
| Dear ForumI am facing the back up fail problem.I have so many bs and have devloped maintaince plan user dbfrom last few days the job fails because ut's not able to backup for two databases.I check the log file it's showing the following errorMicrosoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'H:\MSSQL\backup\FR_RADNOR\FR_RADNOR_db_200710050303.BAK' failed, status = 112. See the SQL Server error log for more details.[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.There is enough space available to take backup. Any help or suggestion to fix this issueSQL IN Minds |
|
|
kishore_pen
Starting Member
49 Posts |
Posted - 2007-10-05 : 07:25:07
|
| use DBCC UPDATEUSAGE & DBCC CHECKDB and then try backup. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-10-05 : 07:25:57
|
| It's saying it can't write to the backup file.Could be a disk error. How big is the backup file?Try writing to a different disk.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-06 : 00:12:47
|
| Check sql server log, it tells you detailed reason. |
|
|
|
|
|
|
Back up problem