SQL Server Performance

Exclusive Access Rights in Log Shipping

Discussion in 'SQL Server Log Shipping' started by mmuneebahmed, Mar 26, 2004.

  1. mmuneebahmed New Member

    Hi Everyone,

    Just would like to find out if I've a standby server restoring transaction logs from my production server every 10mins from 2:00am till 10:00pm and besides a standby server, if we use for reporting purpose as well or may be some users are connected to this read-only database. So, while restoring transaction logs will there be a chance that we can get some exclusive rights issue while restoring transaction logs on Standby Server.

    Thanx

    Muneeb.
  2. satya Moderator

  3. mmuneebahmed New Member

    Thanx Satya for providing me a very useful link. However, one more thing I just wanted to mentioned is while restoring the logs and no one is connected to database except myself. Well, it's not connected just opened the enterprise manager and highlightened the database which is being restored, I get the same exclusive error...Can you please provide me some explanation why it's happening like that.

    Thanx.

    Muneeb.

Share This Page