You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. ABC.com contains a SQL Server 2008 server named ABC-DB01. There are also SQL
Server Agent jobs on the server. Furthermore the database is backed up at a daily basis. One
morning, the master database on ABC-DB02 went down. You then restore and rebuild the master
database. The ABC.com managers want ABC-DB01 to work as it was in the past.
What steps should you take? (Each correct option is part of the answer. Choose TWO)
A.
You should consider rebuilding the entire SQL Server Web Service for the database.
B.
You should consider reserving the model database for the database.
C.
You should consider reserving the Resource databases for the database.
D.
You should consider reserving the tempdb databases for the database.
E.
You should consider reserving the master databases for the database.
F.
You should consider reserving the msdb databases for the database.
G.
You should consider reserving all the Transaction Logs for the database.
H.
You should consider starting from scratch and rebuilding the database of all users’ memories.
Explanation: