You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
Domain.com contains a SQL Server 2008 server named CERTKILLER-DB1.
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 CERTKILLER-DB2 went down. You then
restore and rebuild the database. The Domain.com managers want CERTKILLER-DB1 to work
as it was in the past.
What should you do?
A.
You should consider rebuilding the entire SQL Server Web Service for the database.
B.
You should consider reserving the model and master databases for the database.
C.
You should consider reserving all the Transaction Logs for the database.
D.
You should consider starting from scratch and rebuilding the database of all users’ memories.