Showing posts with label Backup Restore. Show all posts
Showing posts with label Backup Restore. Show all posts

How to restore system databases on lower build

knowledge sharing : Restoring System databases on different build

Issue :

Datafiles and log files are lost on Uat server  due to OS issue
------> Sql server is down
------> All data and log files lost including system database
------> Only backups are available

Suspect Pages in database


On Sunday evening we got an opportunity to run DBC checkdb on one of our suspected database (Of course UAT). And as usual we started checkdb from one of sessions on SQL box query analyzer. By the end of the day we realize it will take some more time to complete and we were expecting that by next day some one will kill our connection , while searching on internet we came to know about a table which gives us report of corruption “msdb..suspect_pages”