Wednesday, March 21, 2012

error defragging index

I received this meesage when trying to defrag an index.
DBCC: Compaction phase of index 'tmxvesta_2.dbo.RNWLWEEK' is 38% complete.
Server: Msg 3624, Level 20, State 1, Line 1
Location: pageref.cpp:1191
Expression: 0 == pageFull
SPID: 68
Process ID: 724
Connection Broken
Can anyone tell me what it means?
Thanks,
--
Dan D.Looks like a bug or the database has a corrupt page. What SP are you
running?
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:78F2C631-D958-475C-88C4-5C610C8E557F@.microsoft.com...
> I received this meesage when trying to defrag an index.
> DBCC: Compaction phase of index 'tmxvesta_2.dbo.RNWLWEEK' is 38% complete.
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: pageref.cpp:1191
> Expression: 0 == pageFull
> SPID: 68
> Process ID: 724
> Connection Broken
> Can anyone tell me what it means?
> Thanks,
> --
> Dan D.|||You're on SP2 and you've hit a bug that is fixed in SP3. You should upgrade
if possible or contact PSS as there may be a hotfix you can apply to SP2.
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:8DAA85A5-072D-4A3F-8E3C-4025D79BD770@.microsoft.com...
> When I run "select @.@.version" I get:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)
> Is service pack 4 for windows or Sql Server?
> --
> Dan D.
>
> "Paul S Randal [MS]" wrote:
> > Looks like a bug or the database has a corrupt page. What SP are you
> > running?
> >
> > --
> > Paul Randal
> > Dev Lead, Microsoft SQL Server Storage Engine
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > news:78F2C631-D958-475C-88C4-5C610C8E557F@.microsoft.com...
> > > I received this meesage when trying to defrag an index.
> > >
> > > DBCC: Compaction phase of index 'tmxvesta_2.dbo.RNWLWEEK' is 38%
complete.
> > > Server: Msg 3624, Level 20, State 1, Line 1
> > >
> > > Location: pageref.cpp:1191
> > > Expression: 0 == pageFull
> > > SPID: 68
> > > Process ID: 724
> > >
> > > Connection Broken
> > >
> > > Can anyone tell me what it means?
> > >
> > > Thanks,
> > > --
> > > Dan D.
> >
> >
> >sql

No comments:

Post a Comment