Exclusive Access Rights in Log Shipping | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Exclusive Access Rights in Log Shipping

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.
Question is answered at thishttp://www.sql-server-performance.com/q&a37.asp Q&A link. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
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.
]]>