SQL Server Performance

SSRS

Discussion in 'SQL Server 2008 General DBA Questions' started by Joben, Dec 26, 2010.

  1. Joben New Member

    Hi Friends,
    Is it possible to create a report on the secondary server configured for log shipping? Please let me know.
    Thank you,
    Joben
  2. Luis Martin Moderator

    Check:
    http://stackoverflow.com/questions/1832848/is-it-possible-to-have-secondary-server-available-read-only-in-a-log-shipping-sce
    HTH
  3. satya Moderator

    Yes its possible but during the TRANSACTION LOG RESTORE job on secondary server, all the connections must be cleared in order to complete. So until the restore is finished your reports will not be able to work/function.

Share This Page