<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Data Corruption
»
SQL Server detected a logical...
SQL Server detected a logical consistency-based I/O error : SQL 2005
Rate Topic
Display Mode
Topic Options
Author
Message
sephrobbertse
sephrobbertse
Posted Thursday, August 30, 2012 2:24 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 5:08 AM
Points: 5,
Visits: 12
Getting this:
Msg 926, Level 14, State 1, Line 2
Database 'DM_m000003_m000002_qdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 824, Level 24, State 2, Line 2
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x627c02d9; actual: 0xb59aada1). It occurred during a read of page (1:6587397) in database ID 9 at offset 0x00000c9080a000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DM_m000003_m000002_qdb.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Msg 3313, Level 21, State 2, Line 2
During redoing of a logged operation in database 'DM_m000003_m000002_qdb', an error occurred at log record ID (116769:7548:175). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
Msg 3414, Level 21, State 1, Line 2
An error occurred during recovery, preventing the database 'DM_m000003_m000002_qdb' (database ID 9) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
Cannot do dbcc, or backup. Any tips?
Post #1352051
opc.three
opc.three
Posted Thursday, August 30, 2012 9:38 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 8:26 AM
Points: 6,737,
Visits: 11,791
Do you have a valid backup that does not contain the corruption?
At minimum you need to restore the corrupt page and possibly more pages leading to the need to restore the entire backup.
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1352321
GilaMonster
GilaMonster
Posted Thursday, August 30, 2012 11:25 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 37,744,
Visits: 30,025
Restore from backup. Don't know offhand if you can do a page restore when a DB is suspect, so may need to be a full restore. How big's the DB?
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1352389
sephrobbertse
sephrobbertse
Posted Thursday, August 30, 2012 12:06 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 5:08 AM
Points: 5,
Visits: 12
Hi, managed to put the DB in emergency mode and do a dbcc repair.
Post #1352407
opc.three
opc.three
Posted Thursday, August 30, 2012 12:55 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 8:26 AM
Points: 6,737,
Visits: 11,791
What kind of repair? You may have lost data that way. Can you post the exact command?
edit: and post output too if you saved it, from that we can tell if you lost data or not
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1352427
GilaMonster
GilaMonster
Posted Thursday, August 30, 2012 1:29 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 37,744,
Visits: 30,025
sephrobbertse (8/30/2012)
Hi, managed to put the DB in emergency mode and do a dbcc repair.
So I assume you have no good backup, since emergency mode repair is the absolute last resort for when there is no backup and every other attempt at resolving the problem has failed.
I strongly suggest that after you've ensured that you database is logically consistent (it probably isn't after the repair), you get a backup routine in place so that if this happens again you don't have to resort the the absolute last chance option.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1352458
GilaMonster
GilaMonster
Posted Thursday, August 30, 2012 1:31 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 37,744,
Visits: 30,025
opc.three (8/30/2012)
What kind of repair? You may have lost data that way. Can you post the exact command?
It'll be CheckDB with REPAIR_ALLOW_DATA_LOSS as no other repair option is allowed when a DB is in emergency mode.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1352462
opc.three
opc.three
Posted Thursday, August 30, 2012 1:35 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 8:26 AM
Points: 6,737,
Visits: 11,791
GilaMonster (8/30/2012)
opc.three (8/30/2012)
What kind of repair? You may have lost data that way. Can you post the exact command?
It'll be CheckDB with REPAIR_ALLOW_DATA_LOSS as no other repair option is allowed when a DB is in emergency mode.
Ahh, I breezed right over the comment about putting it in 'emergency mode.' Thanks.
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1352465
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
