PageViews Last Month

Friday, 11 September 2015

Data Needed to Recover SQL server from a Host Crash


Am sure every DBA has once in his/her career  come across a situation of recovering a database or an instance of a database server. Reasons may vary for the database or server to go offline. However at times like a Windows Host Crash where the DBA's are required to rebuild an entire database instance from scratch below details may come in handy for rebuilt purposes.

1.            SQL version, port, memory and cpu details (available in the verification documents & cmdb entries)

2.            Drive & space information

3.            Number of instances installed

4.            Instance specific non-default configuration details(Eg:32-bit,64-bit Aliases)

5.            SQL service information (If the host also deployed SSIS & SSRS)

6.            Latest verified backups for system and user databases.

7.            Any external drive mapping details

8.            SSIS or DTS local package information and files

9.            SSRS local reports and projects

10            SSIS/SSAS local projects
  
10.          Local application queries if any

11.          SQL aliases configuration details


(Note: Any SQL DR strategy deployed should also provide the above information if configured wisely )

It's wise to have the inventory updated and maintained with all these details to avoid running around for the same.There could be many more details however these are the top few that occur to me when I hear System Crash :)

No comments:

Post a Comment