PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the database backups can be restored on another SQL Server 2008 instance if the origin

You administer a SQL Server 2008 infrastructure. Several production databases use
Transparent database encryption. You perform full database backups of the production
databases as part of your backup strategy. You need to ensure that the database backups
can be restored on another SQL Server 2008 instance if the original host server fails. What
should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Back up the server master key.

B.
Back up the database master key.

C.
Ensure that the instances use the same service account.

D.
Back up the resource database.

Explanation:


Leave a Reply