3. You are setting up log shipping for a database between two instances of SQL
Server 2008. You want to ensure that your users have access to the database
when the logs are not actively being restored so that they can read the updated
data for reporting purposes. In what state should you leave the database?
A. RECOVERY
B. NO RECOVERY
C. STANDBY
Answer C is the correct answer. If you leave the database in the STANDBY
state the users can connect to the database, which is left in a read-only state, and
query it. If the database is in a RECOVERY state then you will not be able
to restore any more logs to it. If the database is in a NO RECOVERY state
then the users will not be able to access it at all. If you do this, be sure to tell
the log shipping to disconnect the users when restoring the backups.
Bạn đang xem 3. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P148 PPT