Guys,
Apologies if this is in the wrong section. I have a SQL 2000 database which I backup to a folder on the hard disk using the following command in a Server Agent:
BACKUP DATABASE [Multilog] TO DISK = N'C:\MSSQL7\BACKUP\multilog_backup' WITH INIT , NOUNLOAD , NAME = N'Multilog backup', NOSKIP , STATS = 10, NOFORMAT
Recently it has been failing with the following error message:
Nonrecoverable I/O error occurred on file 'C:\Multilog Database Files\Data\MultiLog_data.MDF'. [SQLSTATE 42000] (Error 3271) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Any idea what could be causing this
Any help would be greatly appreciated.
Sean.
Backup File I/o Error
Caga
Try some of the method(s) in the following kb:
http://support.microsoft.com/default.aspx/kb/904804
Is this an SP4 server Looks like it may have been upgraded from SQL 7.0, is that correct
irsprint
Yeah, that would indicate a data integrity issue within your DB file. Try running a DBCC CHECKDB on the database in question and see what you get for output. Depending on the output of that, you could try using the FIX options with the CHECKDB command, rebuilding indexes, etc.
masterbuyerseller
Chad,
Just noticed the following error on the logs:
I/O error 23(Data error (cyclic redundancy check).) detected during read of BUF pointer = 0x14243d80, page ptr = 0x1607c000, pageid = (0x1:0x1ae), dbid = 5, status = 0x801, file = C:\Multilog Database Files\Data\MultiLog_data.MDF..
Would this indicate a fault with the actual database file Any idea what could be done to check and fix