question

Therealist avatar image
Therealist asked

Database suspect mode issue?

If we restore the master Db with the help of a backup due to any corrupt or missing files, Are we going to have the user databases as consistent as they were before server shutdown? Or Do we have to restore them as well from available backups?
backup-restorecorruptionmaster
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
raadee avatar image
raadee answered
It depends, there are examples of situations that could occur. **Example:** If you recently added a datafile to a user database, then restore the master database to a point in time before you added the datafile to the user database. This datafile would be missing in sys.files. Same goes for logins and so on.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.