Problem 3: Allocation Pages from Deleted Database

disk refit finds allocation pages from a previously deleted database; another database was subsequently created that reuses the dbid of the old database, but the combined set of sysusages entries created from these allocation pages do not cause any duplicate keys in sysusages.

Symptom: Rows exist in sysusages such that (lstart + size) of a previous entry with the same dbid does not equal this row’s lstart.

Corrective Action: Follow the instructions in "Queries to Find Suspect sysusages Entries" below. Be sure to delete any row whose sysusages.lstart does not equal the (lstart + size) of the preceding entry.

WARNING! When correcting this problem, work from low to high lstart. Delete the lowest incorrect row first. This ensures that you do not accidentally delete an entry that should be there, because its lstart did not match the (lstart + size) of an earlier row that should not be there.