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:
Why not B and F (instead of B and E) ?
The master-DB had already been restored and rebuilt.
Now we should have a look at other important system-DBs :
(B) model-DB
(F) msdb-DB
Point (F) does matter here for sure, because important data and settings of SQL-Server-Agent-Jobs are stored in the msdb-DB.
Point (B) : The tempdb-DB is created automatically during startup based on the model-DB and does not need to be handled. This is only one of a lot good reasons for a good preparation of the model-DB.
information sources :
@see http://www.mssqltips.com/sqlservertip/1420/sql-server-system-databases/
@see http://www.mssqltips.com/sqlservertip/1531/rebuilding-the-sql-server-master-database-part-1-of-3/ a.s.o.
@see http://www.mssqltips.com/sqlservertip/3266/restoring-the-sql-server-master-database-even-without-a-backup/
0
0