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.
|||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...
>
>
|||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)[vbcol=seagreen]
> Is service pack 4 for windows or Sql Server?
> --
> Dan D.
>
> "Paul S Randal [MS]" wrote:
rights.[vbcol=seagreen]
complete.[vbcol=seagreen]
No comments:
Post a Comment