June 19, 2007 at 5:59 am
Hi
I have Database in SQL-Server2000 size is 1.37 GB i am tryn to take backup followin are the problems:-
1. Maintainence Plan for Backup Fails for DB
2. Jobs fails for Backup
--> I goto SQL Server Logs Error message is Operating system error 23(Data error (cyclic redundancy check).)
--> Now i am tryin Backup using command :-
Backup Database 'DB1' To Disk ='Path' followin error occurs:-
"Nonrecoverable I/O error occurred on file"
--> Now i am doing back-up directly from Enterprise Manager following error message occurs same error comes
Whats surprising Jobs, maintainence plan, Backup for other database is working perfectly, i checked HDD doesnt have any bad
blocks etc. i have even changed path for Backups but still only for these database it gives problem
With Regards
June 19, 2007 at 6:08 am
Did you run the consistency checker on the database and see if there is any errors that it resulted. your error is an outpt of CRC and this would be because of mismatch in OS level files.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply