Incorrect PFS free space information for page
This is just a personal experience, so if this destroys your house or eats your dog, then don’t blame me.
If you run a DBCC CheckDB on your SQL server database, and get an error such as
Incorrect PFS free space information for page (1:7394) in object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
Then, you can repair this error using
ALTER DATABASE xxxxx
SET single_user WITH ROLLBACK IMMEDIATE;
go
DBCC checkdb (‘xxxx’, repair_allow_data_loss);
go
What this command does, is delete any erroneous pages, which removes the error, but will also delete any data contained in the erroneous pages. If the affected data can be sacrificed, then you can use this to recover the rest of the database.
Note: You will need to put the database back into multi user mode afterwards!
ALTER DATABASE xxxxx SET multi_user
LikeLike
danasos is right!
And try to repair without ‘data_loss’ flag first:
dbcc checktable(DocStreams, REPAIR_FAST) WITH ALL_ERRORMSGS;
GO
dbcc checktable(DocStreams, REPAIR_REBUILD) WITH ALL_ERRORMSGS;
LikeLike