SQL Server 2005 log shipping

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  August 10, 2011 at 8:35 am

  #390164

  Hi,

  I have configured log shipping on SQL Server 2005 database. Now my log shipped database is in restoring mode. Is there any way to keep this database in read mode so I can read the data.

  Thanks in advance.

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  August 10, 2011 at 10:04 am

  #1366703

  please execute the following against your log shipped secondary database and post back the results

  exec sp_help_log_shipping_secondary_database @secondary_database = 'secondary_database'

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉