You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. The Domain.com’s SQL Server 2008
is configured to make use of the -T1222 and -T1204 trace flags while booting up. You have
received instructions to make sure that the use of these trace flags are also included in the
recovery method of the backups.
What should you do?
A.
You should consider backing up the SQL Server Log.
B.
You should consider backing up the default database.
C.
You should consider backing up the SQL Server registry hive.
D.
You should consider backing up the master database.
E.
You should consider using a stored procedure.