YOU ARE SETTING UP LOG SHIPPING FOR A DATABASE BETWEEN TWO INSTANCE...

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.