Home » Microsoft » MB2-708 » Which two databases should you include in the disaster recovery plan?
You have a deployment of Dynamics CRM 2015 that contains one organization named ORG1.
You need to create a disaster recovery plan for the deployment.
Which two databases should you include in the disaster recovery plan? Each correct answer presents part of the solution?
A. msdb
B. mscem_config
C. master
D. org1_mscrm
E. tempdb
Correct Answer: AC
Explanation/Reference:
A: The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail. For example, SQL Server automatically maintains a complete online backup-and-restore history within tables in msdb. This information includes the name of the party that performed the backup, the time of the backup, and the devices or files where the backup is stored.
C: The master database records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings. In SQL Server, system objects are no longer stored in the master database; instead, they are stored in the Resource database. Also, master is the database that records the existence of all other databases and the location of those database files and records the initialization information for SQL Server. Therefore, SQL Server cannot start if the master database is unavailable.