error 17052

Error: 644, Severity: 21, State: 3
Could not find the index entry for
RID '36100101406d0610730740650720' in index page (1:257),
index ID 0, database 'master'.
Any help or direction would be greatly appreciated.
ThanksHave you run a dbcc checkdb on the master database?
You can run this with the repair option and see if it
fixes your problem.
>--Original Message--
>Error: 644, Severity: 21, State: 3
>Could not find the index entry for
>RID '36100101406d0610730740650720' in index page (1:257),
>index ID 0, database 'master'.
>Any help or direction would be greatly appreciated.
>Thanks
>.
>|||I have not. I can not get the sql server service to start.
This might help:
2003-11-19 09:30:58.55 server Microsoft SQL Server
2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195:
Service Pack 4)
2003-11-19 09:30:58.55 server Copyright (C) 1988-2002
Microsoft Corporation.
2003-11-19 09:30:58.55 server All rights reserved.
2003-11-19 09:30:58.55 server Server Process ID is
2416.
2003-11-19 09:30:58.55 server Logging SQL Server
messages in file 'd:\sqlroot\MSSQL\log\ERRORLOG'.
2003-11-19 09:30:58.57 server SQL Server is starting
at priority class 'normal'(4 CPUs detected).
2003-11-19 09:30:58.66 server SQL Server configured
for thread mode processing.
2003-11-19 09:30:58.66 server Using dynamic lock
allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2003-11-19 09:30:58.74 server Attempting to initialize
Distributed Transaction Coordinator.
2003-11-19 09:31:00.79 spid3 Starting up
database 'master'.
2003-11-19 09:31:00.93 spid3 0 transactions rolled
back in database 'master' (1).
2003-11-19 09:31:00.93 spid3 Recovery is
checkpointing database 'master' (1)
2003-11-19 09:31:00.94 spid3 Error: 644, Severity:
21, State: 3
2003-11-19 09:31:00.94 spid3 Could not find the index
entry for RID '36100101406d0610730740650720' in index
page (1:257), index ID 0, database 'master'..
2003-11-19 09:31:00.94 spid3 Cannot recover the
master database. Exiting.
>--Original Message--
>Error: 644, Severity: 21, State: 3
>Could not find the index entry for
>RID '36100101406d0610730740650720' in index page
(1:257),
>index ID 0, database 'master'.
>Any help or direction would be greatly appreciated.
>Thanks
>.
>|||Read about rebuilding the master database (rebuildm.exe). That will clear out all system databases,
so after that you need to restore master and msdb in order to get that stuff back.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"eric" <anonymous@.discussions.microsoft.com> wrote in message
news:021201c3aed1$375103c0$a401280a@.phx.gbl...
> I have not. I can not get the sql server service to start.
>
> This might help:
> 2003-11-19 09:30:58.55 server Microsoft SQL Server
> 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195:
> Service Pack 4)
> 2003-11-19 09:30:58.55 server Copyright (C) 1988-2002
> Microsoft Corporation.
> 2003-11-19 09:30:58.55 server All rights reserved.
> 2003-11-19 09:30:58.55 server Server Process ID is
> 2416.
> 2003-11-19 09:30:58.55 server Logging SQL Server
> messages in file 'd:\sqlroot\MSSQL\log\ERRORLOG'.
> 2003-11-19 09:30:58.57 server SQL Server is starting
> at priority class 'normal'(4 CPUs detected).
> 2003-11-19 09:30:58.66 server SQL Server configured
> for thread mode processing.
> 2003-11-19 09:30:58.66 server Using dynamic lock
> allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
> 2003-11-19 09:30:58.74 server Attempting to initialize
> Distributed Transaction Coordinator.
> 2003-11-19 09:31:00.79 spid3 Starting up
> database 'master'.
> 2003-11-19 09:31:00.93 spid3 0 transactions rolled
> back in database 'master' (1).
> 2003-11-19 09:31:00.93 spid3 Recovery is
> checkpointing database 'master' (1)
> 2003-11-19 09:31:00.94 spid3 Error: 644, Severity:
> 21, State: 3
> 2003-11-19 09:31:00.94 spid3 Could not find the index
> entry for RID '36100101406d0610730740650720' in index
> page (1:257), index ID 0, database 'master'..
> 2003-11-19 09:31:00.94 spid3 Cannot recover the
> master database. Exiting.
> >--Original Message--
> >Error: 644, Severity: 21, State: 3
> >Could not find the index entry for
> >RID '36100101406d0610730740650720' in index page
> (1:257),
> >index ID 0, database 'master'.
> >
> >Any help or direction would be greatly appreciated.
> >
> >Thanks
> >.
> >|||On Wed, 19 Nov 2003 08:21:35 -0800, "eric"
<anonymous@.discussions.microsoft.com> wrote:
>Error: 644, Severity: 21, State: 3
>Could not find the index entry for
>RID '36100101406d0610730740650720' in index page (1:257),
>index ID 0, database 'master'.
hi Eric,
we encountered the same issue on a freshly install of an
active/passive cluster Windows 2000 AS SP4 with SQLServer 2000 SP3.
the issue comes out when we try to move related cluster services from
node A to node B.
apart of fixing the master table, I'd be interested on knowing the
cause of such index curruption.
have you got any ideas?
thank you.
--
Francesco "Matro" Martire
available at www.realpopup.it:
RealPopup, the freeware winpopup replacer
RealAccount, freeware plugin for MS Outlook XP
MaTreo, freeware frontscreen for your Treo and PalmOS devices