dbcc checkdb

[bab]

I ran "dbcc checkdb(MCMSdb) with no_infomsgs" and I get the following:
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:274992) has invalid PFS_PAGE page
header values. Type is 0. Check type, object ID and page ID on the
page.

What cane be done to correct this problem?
Can this error prevent a user from connecting to the database?

[Erland Sommarskog]

bab (ba*******@gmail.com) writes:

I ran "dbcc checkdb(MCMSdb) with no_infomsgs" and I get the following:
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:274992) has invalid PFS_PAGE page
header values. Type is 0. Check type, object ID and page ID on the
page.

What cane be done to correct this problem?

You can search on the string 8946 in Books Online.

As I understand the topic, the only way to repair is restore from a
clean backup. DBCC can repair many problem, but the topic says that if
the error is in an PFS_PAGE it's not repairable. (I'm looking at Books
Online for SQL 2000. 2005 may be different.)

Can this error prevent a user from connecting to the database?

As such, I don't think so. But a user who hits this broken page may
experience an assertion error and be disconnected. And if the page is
hit while logging into the server, then connection may fail.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Paul S Randal [MS]]

This error can't be repaired in any version of SQL Server - you must restore
from a backup.

--
Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
http://blogs.msdn.com/sqlserverstora...e/default.aspx

This posting is provided "AS IS" with no warranties, and confers no rights.

"Erland Sommarskog" <es****@sommarskog.sewrote in message
news:Xn*********************@127.0.0.1...

bab (ba*******@gmail.com) writes:

>I ran "dbcc checkdb(MCMSdb) with no_infomsgs" and I get the following:
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:274992) has invalid PFS_PAGE page
header values. Type is 0. Check type, object ID and page ID on the
page.

What cane be done to correct this problem?

You can search on the string 8946 in Books Online.

As I understand the topic, the only way to repair is restore from a
clean backup. DBCC can repair many problem, but the topic says that if
the error is in an PFS_PAGE it's not repairable. (I'm looking at Books
Online for SQL 2000. 2005 may be different.)

>Can this error prevent a user from connecting to the database?

As such, I don't think so. But a user who hits this broken page may
experience an assertion error and be disconnected. And if the page is
hit while logging into the server, then connection may fail.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx