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.
May I suggest the following re-write for this question:
You work as a database administrator at Domain.com.
Domain.com contains a SQL Server 2008 server named CERTKILLER-DB1.
There are multiple SQL Server Agent jobs on the server. All system databases are backed up on a
daily basis.
One morning, the MASTER database on CERTKILLER-DB2 becomes corrupted.
You have been asked to rebuild the database instance.
The Domain.com managers want CERTKILLER-DB1 to be configured in the same way that it was before the MASTER database became corrupted.
Each answer presents part of the solution. Choose two.
A.
You should rebuild the SQL Server Web Service for the instance.
B.
You should rebuild the MODEL and MASTER databases for the instance.
C.
You should restore the MSDB database from backup.
D.
You should restore all of the Transaction Logs for the instance.
E.
You should starting from scratch and rebuild all user databases.
F.
You should rebuild the MASTER database for the instance
Correct answers are C and F:
F -You should rebuild the MASTER database for the instance: If the MASTER database for an instance becomes corrupted the instance will not start. This database must be rebuilt using the command line SETUP.EXE utility.
C – You should restore the MSDB database from backup: The MSDB database contains all of the data used by SQL Server Agent, including information about scheduled jobs.