Hello,
I use ver 8.04 and SQL2005 DB. Unfortunatelty DB have critical errors (shown by DBCC CHECKDB):
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:34; actual 2:2). It occurred during a read of page (1:34) in database ID 8 at offset....
According to documentation it's corrupted DB due to hardware issue and I can't find necessary command to fix it
But I can export (not copy database - in this case the same error happened) all data into another DB!! Could you please help me how to
- import data into fresh, but prepared DB (after keys/relations created by standard script) from production DB. I can't import data (through admin console) into DB with keys/relattions/etc
OR
- create standard keys/relations/etc after data exported to new DB. Standard script don't created relations/keys if runned on DB with data
Thank you in advance - I have to fix issue ASAP until my data loss
Edited by ask023 - 16 December 2006 at 9:31pm
Topic Options
Post Options
Thanks(0)
