Home > Uncategorized > Incorrect PFS free space information for page

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.

 

Advertisements
Categories: Uncategorized
  1. November 16, 2012 at 11:24 am

    Note: You will need to put the database back into multi user mode afterwards!

    ALTER DATABASE xxxxx SET multi_user

  2. October 14, 2016 at 4:03 pm

    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;

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: