|
|
Posted by Erland Sommarskog on 08/28/06 21:45
bab (babitap31@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, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|