Home Forums SQL Server 2005 Administering How to make log-shipped database to be available for queries RE: How to make log-shipped database to be available for queries

  • When you create the log shipping you have 2 choices. You can configure restore log operation to be done with norecovery or with standby option. If you use the norecovery option, you can not issue select statements on it. If instead of norecovery you use the standby option, you can run select queries on the database. Notice that in that case you also have to make the decision what to do when it is time to restore the log, but there are users that are using the database. You’ll have to wait with the restore or to kill the users’ processes before issuing the restore log statement. All of those options can be configured with the wizard.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/