CODEWITHSUNDEEP
sql-server-2008
sriakanth
sriakanth

Reputation: 29

trouble shooting if master db got into suspect or corrupted

Recently I attended an interview. The interviewer asked me what are the steps to follow if the master db got into a suspect state or if it is corupted? What is the correct answer to this question?

Upvotes: 0

Views: 244

Answers (1)

gbn
gbn

Reputation: 432271

  1. If SQL Server won't start, then you have to rebuild.
    Also on MS CSS SQL Server Engineers blog
  2. Start in single user mode
  3. Then you can restore it

This is fundamental DBA knowledge: you should have some knowledge before it happens. And have practised it too

Upvotes: 2

Related Questions