Re: Keys out of order on page error
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/10/04
- Next message: Tibor Karaszi: "Re: sqlserver agent starts and then immediately stops"
- Previous message: John Bull: "Disk Reads and writes"
- In reply to: Peter The Spate: "Keys out of order on page error"
- Next in thread: Jacco Schalkwijk: "Re: Keys out of order on page error"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 10 Aug 2004 18:44:13 +0200
In addition:
The latest update of Books Online has some very detailed recommendations for most error numbers.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Peter The Spate" <anonymous@discussions.microsoft.com> wrote in message news:374a01c47eee$f6a6a890$a501280a@phx.gbl... > There are a couple of things. > > Firstly it is very intensive so turn off as many services > you can get away with, i.e SQL Agent > > Secondly depending upon the severity of the error it may > result in data loss. Personally I would try firstly with > REPAIR_FAST, then REPAIR_REBUILD and if all else fails > REPAIR_ALLOW_DATA_LOSS, its that option where you may lose > data. > > If the REPAIR_ALLOW_DATA_LOSS doesn't work then you will > have to restore from backup. > > As for the reason why to difficult to say. > > Good luck > Peter > > > >-----Original Message----- > >We have found we have corruption in our db. > > > >After running DBCC CHECKDB the following error were > displayed on > >multiple pages. > > > >Server: Msg 2511, Level 16, State 1, Line 1 > >Table error: Object ID 1285579618, Index ID 3. Keys out > of order on page > >(1:384662), slots 75 and 76. > > > >I read a post that suggested running DBCC CHECKDB with > the repair_build > >option. > > > >Since we are a 24/7 shop I cannot restore from tape, > because it would > >take several hours. > > > >What are the risks of running DBCC CHECKDB with the > repair_build option, > >and will this fix the problem properly? > > > >We are still unsure what has caused this corruption, any > body else have > >this problem? > > > >TIA, > > > >-Ben > >. > >
- Next message: Tibor Karaszi: "Re: sqlserver agent starts and then immediately stops"
- Previous message: John Bull: "Disk Reads and writes"
- In reply to: Peter The Spate: "Keys out of order on page error"
- Next in thread: Jacco Schalkwijk: "Re: Keys out of order on page error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
