March 5, 2004 at 4:55 pm
Hi,
I required to take the backup of the database and got the message saying that the ODBC SQL State :42000 and the write to the back up file is failing with the status = 112. The backup operation is terminating abnormally.
I can think of that this wud have caused because of the transactions going on on the server and the server's busy state wasn't allowing for the successfull backup to happen.If the server is restarted and the backup is taken, then it goes thru successfully.
please let me know if anybody is aware of the solution for this and also the details of the problem.The server restart shouldn't be required.
Thanks!
March 8, 2004 at 8:00 am
This was removed by the editor as SPAM
March 8, 2004 at 8:48 am
It looks like you may be backing up over the network?? Usually if it fails to write to the backup it is because another process is locking the backup file or it is running over the network and loosing connection at some point. You are correct you shouldn't have to restart sql server at all. Also, SQL backups are non-blocking and shouldn't be horribly effected by user transactions unless the voume is very high or the machine in question is very very slow i.e. single proc single disk that kind of thing.
Wes
March 8, 2004 at 11:33 am
How are you doing the backups? Are you using SQL Server backup commands or are you using third-party software?
-SQLBill
March 9, 2004 at 5:22 pm
I have many times for status = 112. It always shows that there
is not enough disk space on the backup device. You might check
your backup device space.
Robert
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply