What action should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. ABC.com’s SQL Server 2008 is configured
to make use of the 7806 trace flag while booting up. You have received instructions to make sure
that the use of this trace flag is included in backups.
What action should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. ABC.com’s SQL Server 2008 is configured
to make use of the 7806 trace flag while booting up. You have received instructions to make sure
that the use of this trace flag is included in backups.
What action should you take?

A.
You should consider including a backup of 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.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *