1

sql 2012 master database is corrupted, i have recent backup of master, what will happen to my user databases after restoring master, do i have to restore all db's from latest backups?

Thanks

  • 1
    If the backup of master database was taken recently and assuming it had all the information and you did not added any database after taking this backup, there would hardly be any affect. Please note that anything added in master DB after this backup would be lost. And no after restoring master you do not have to restore user database – Shanky Jul 10 '18 at 17:16
1

If you need to restore master, and it's a current backup of the master database, then nothing should need to be done to your user databases, logins, linked servers, etc.

There's the deeper question of why the master database is being corrupted, but that can wait until after the system is back up and the business unit can function again.

  • We do not have any clue on corruption, restored master database with backup – Sunny Nov 8 '18 at 17:35
6

If any database is corrupted, I start to worry about the storage it lives on. If you haven't identified the root cause of the corruption yet - like a bad storage driver, a bad storage cable, a failing RAID array, or maybe even a known bug in SQL Server - then I'd start by assuming that the server and its storage is not completely reliable.

I'd start by failing over to a different server on different storage, and run CHECKDB against all of your user databases (not just master) to make sure they're okay. (Don't think that a clean CHECKDB on the existing server means you're out of the woods - master might have just been the first place that storage decided to corrupt.)

For much more details, check out my post, What to Do When DBCC CHECKDB Reports Corruption, which includes a checklist on:

  1. Turn off your backup-delete jobs
  2. Query the msdb.dbo.suspect_pages table
  3. If you're using a SAN, alert the storage team
  4. Alert the application owners and stakeholders
  5. Review the history of your CHECKDB and backup jobs

And more.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.