March 17, 2008 at 8:14 am
I am using Sql Server 2000. After taking data backup, it says
I/O Error (Bad Page Id) detected during reat at offset 0x00000000862000 in file 'E:\DATABASE\myDB.mdf'.
March 17, 2008 at 1:13 pm
May the following discussion help.
http://en.allexperts.com/q/MS-SQL-Server-1801/O-error-bad-page.htm
March 17, 2008 at 1:36 pm
Do you have a previous database backup?
Run the following and see what it says.
DBCC CHECKDB ('MyDB') with no_infomsgs
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 21, 2008 at 1:47 pm
You can also query msdb for suspect pages.
SELECT * FROM msdb..suspect_pages
March 21, 2008 at 1:48 pm
More info on searching for suspect pages.
March 21, 2008 at 2:01 pm
Adam Haines (3/21/2008)
You can also query msdb for suspect pages.SELECT * FROM msdb..suspect_pages
On SQL 2005 only.
Palwi: Questions related to SQL 2000 should rather go into the sql 2000 forums. Otherwise you'll get a lot of suggestions that won't work.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 23, 2008 at 8:40 am
On SQL 2005 only.
Palwi: Questions related to SQL 2000 should rather go into the sql 2000 forums. Otherwise you'll get a lot of suggestions that won't work.
Yep. I missed the 2000 part. Thanks for pointing it out.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply