DBCC INTEGRITY CHECK ERROR:Msg 8948, Sev 16, State 6, Line 1 : Database error: Page (1:36729) is marked with the wrong type in PFS page (1:32352). PFS status 0x40 expected 0x60. [SQLSTATE 42000]
I got the below when on one of the Always on Databases while we are running DBCC INTEGRITY CHECK job.
We need to bring the database to single user mode and need to execute REPAIR_ALLOW_DATA_LOSS. However this is not going to delete any data.
(https://www.sqlskills.com/blogs/paul/pfs-corruption-after-upgrading-from-sql-server-2014/)
We need to bring the database to single user mode and need to execute REPAIR_ALLOW_DATA_LOSS. However this is not going to delete any data.
(https://www.sqlskills.com/blogs/paul/pfs-corruption-after-upgrading-from-sql-server-2014/)
Comments