Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chetan_dba
Starting Member
21 Posts |
 Posted - 2008-04-08 : 01:27:25
|
| Hi,I have following question ( same was asked to me by my collegue)I have Log shipping between two servers ( say Server A - Primary & Server B - Secondary). One user is logged in to B Server and fired a long query on the same database / object. it is taking a very long time to execute.Q : How this will impact the log shipping process ?Ans : Log shipping will fail as the secondary db will show as " database is in use" for log shipping process.Q : How to recover the log shipping process?And : Notify the user to disconnect the session / or kill the user session. But i don't know how to recover the log shipping.Thanks in advance.-- Chetan |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-08 : 02:15:43
|
| 1. If you selected the option in the log shipping wizard setup to disconnect the users during the restore, then the user will get disconnected once the restore job kicks off. I recommend that this option always be checked, otherwise log shipping will fail.2. You don't need to recover it. It'll pickup again once the restore job kicks off, or you can manually kick it off.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Log Shipping Help