This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Recreate default Sophos NAC database (PolicyStore_Data.MDF)

Hi,

While trying to upgrade Enterprise Console to v 9.5 we've encountered a problem with the PolicyStore_Data.MDF, specifically this here:

-------------------------------

Event Type:    Error
Event Source:    MSSQL$SOPHOS
Event Category:    (2)
Event ID:    824
Date:        08.01.2011
Time:        15:00:03
User:        BU-S048\SophosNAC
Computer:    BU-S048
Description:
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:83; actual 121:7471205). It occurred during a read of page (1:83) in database ID 10 at offset 0x000000000a6000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\PolicyStore_Data.MDF'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 38 03 00 00 18 00 00 00   8.......
0008: 0f 00 00 00 42 00 55 00   ....B.U.
0010: 2d 00 53 00 30 00 34 00   -.S.0.4.
0018: 38 00 5c 00 53 00 4f 00   8.\.S.O.
0020: 50 00 48 00 4f 00 53 00   P.H.O.S.
0028: 00 00 0c 00 00 00 50 00   ......P.
0030: 6f 00 6c 00 69 00 63 00   o.l.i.c.
0038: 79 00 53 00 74 00 6f 00   y.S.t.o.
0040: 72 00 65 00 00 00         r.e...  
-------------------------------

So far it seems that the database is unrecoverable, preventing the upgrade.
We've tried several steps to recover it (dbcc checkdb, copy to another server and trying to attach, chkdsk etc.). Restoring it is not an option since this specific database has never been configured for backup.


Is there any way to recreate the default DB except reinstalling NAC intirely?



Best Regards

:8181


This thread was automatically locked due to age.