Viewing 15 posts - 91 through 105 (of 233 total)
Step 3 is for principle. You can not run that on Mirror since it is in restoring mode.
May 14, 2013 at 7:35 am
Please find attached the step by step script to reproduce the issue. What I realized that unless you explicitly specify DEFAULT_DATABASE=your Mirrored DB, it does not work.
May 14, 2013 at 7:00 am
So, if you have done that..post he create table & some sample data script..
May 13, 2013 at 1:14 pm
When setting up Publication did you check the check box for "Create/ schedule the snapshot agent?" and then initialized from backup?
May 13, 2013 at 1:09 pm
Thank you very much Lynn for asking me to write the step by step script for you to replicate issue on your side.
While I was doing that I just realized...
May 13, 2013 at 11:04 am
Yes, I add the user to 2 roles in mirror and it is high safety and failing over automatically.
May 12, 2013 at 2:22 pm
Could you please post the detailed error message? Is this related to a network issue?
May 11, 2013 at 9:26 am
Lynn,
Please let me know what information you want. I will provide as much as information I could give.
It is standard mirroring set up with high safety.
All the Servers...
May 10, 2013 at 7:41 pm
Yes, that's right and also using the same SID as of primary.
May 10, 2013 at 7:31 pm
What I was trying to ask that when ever a deadlock happens there are always 2 parties involved. Do by any chance you know the second party?
May 10, 2013 at 11:52 am
SQL server error log will also be showing which resource it is conflicting with causing deadlock.
May 10, 2013 at 11:35 am
How you are validating from the SQL Server Error Log that it is replication monitoring causing the deadlock?
May 10, 2013 at 10:08 am
Could you please share SQL server error log?
Never seen Replication Monitor causing dead lock but if you share your error log, it might help understanding actual issue.
May 10, 2013 at 7:25 am
Viewing 15 posts - 91 through 105 (of 233 total)