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?bab (babitap31@.gmail.com) writes:
Quote:
Originally Posted by
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.)
Quote:
Originally Posted by
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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||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/sqlserverstor...ne/default.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
news:Xns982DF1C2574BYazorman@.127.0.0.1...
Quote:
Originally Posted by
bab (babitap31@.gmail.com) writes:
Quote:
Originally Posted by
>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.)
>
Quote:
Originally Posted by
>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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
No comments:
Post a Comment