SQL Server Performance Forum – Threads Archive
Exclusive Access Rights in Log ShippingHi 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
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.