|
|
Posted by Paul S Randal [MS] on 08/29/06 04:09
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/sqlserverstorageengine/default.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns982DF1C2574BYazorman@127.0.0.1...
> 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]
|