Share via

MASTER Database SGAM page corrupted

Allen Francis 26 Reputation points
2020-08-19T21:23:34.09+00:00

MASTER Database SGAM page corrupted and it says object id 99 but when in search in sysobjects table there is no 99 object id.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,948 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,981 Reputation points Microsoft Vendor
    2020-08-20T03:44:35.63+00:00

    Hi AllenFrancis-7154,

    Do you have a valid backup of the database? You can try to restore the backup of database currently.

    In addition, could you please share us the detailed error message returned by dbcc checkdb?

    Best Regards,

    Amelia

    0 comments
  2. tibor_karaszi@hotmail.com 4,311 Reputation points
    2020-08-20T06:43:52.373+00:00

    We need the error messages, including the final statement. But GAM and SGAM corruptions are rarely a good sign (if there ever is when it comes to corruption). So be prepared to restore from a backup.

    Considering this is the master database, if you don't have a backup you'd be in for attaching or restoring all your user databases to a new SQL Server (or if you do a rebuild) and then re-create everything which you have in the master database (logins, linked servers etc). Messy and tiresome, but most likely doable.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.