Tag Archives: DBCC errors

How to Use DBCC CHECKDB in SQL Server

How to Use DBCC CHECKDB in SQL Server Use: By far the most widely used command to check the status of your database is DBCC CHECKDB. This statement checks the allocation and structural integrity of all data and index pages … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , , , , , , | 2 Comments

SQL Server: Incorrect PFS free space information for page (1:xxxx) in object ID xxxxxx:

SQL Server: Incorrect PFS free space information for page (1:xxxx) in object ID xxxxxx:   “Incorrect PFS free space information for page (1:233791) in object ID 367392428, index ID 1, partition ID 72057594180730880, alloc unit ID 72057594222018560 (type LOB data). … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , , , , , | 3 Comments