Reputation
514
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 9 27
Impact
~55k people reached

  • 0 posts edited
  • 0 helpful flags
  • 63 votes cast
Jan
4
comment How can I log the most CPU-Intensive processes in regular intervals?
Thanks a lot! :)
Jan
3
asked How can I log the most CPU-Intensive processes in regular intervals?
Dec
16
awarded  Popular Question
Sep
2
awarded  Notable Question
Jul
9
awarded  Popular Question
Jul
2
awarded  Popular Question
Apr
8
awarded  Popular Question
Mar
2
awarded  Popular Question
Feb
17
awarded  Nice Question
Dec
29
accepted Does SQL Server 2008 R2 Web edition support CSV and XML export?
Dec
29
answered Does SQL Server 2008 R2 Web edition support CSV and XML export?
Dec
12
comment Cannot add witness to my mirroring setup
The next line after the one you quoted restarts the mirroring session.
Dec
10
comment Cannot add witness to my mirroring setup
I think you are confusing this with the "alter database <dbname> set partner <hostname>" command. That one has to be executed on the mirror first, then on the principle. "Set witness" is only initiated on the principal - if you try to run it on the mirror, you get the following error: "Msg 1470, Level 16, State 2, Line 1 The alter database for this partner config values may only be initiated on the current principal server for database MYDBNAME"
Dec
10
comment Cannot add witness to my mirroring setup
I think the reason I did not get any monitoring data from the witness is that it raises less events than the principal and the event types are different as well. Please see my edit 3 above.
Dec
10
revised Cannot add witness to my mirroring setup
added 1151 characters in body
Dec
10
revised Cannot add witness to my mirroring setup
added 822 characters in body
Dec
10
revised Cannot add witness to my mirroring setup
added 42 characters in body
Dec
9
comment 10 servers to administer and I'm a history major
I'd like to express my sincere sympathy by upvoting this posting.
Dec
9
comment Cannot add witness to my mirroring setup
Thanks for the suggestion. I could not find the "Audit Database Mirroring Login" event (which event section is it? I searched all of "Security Audit", but it wasn't there). I added the results to my post above.
Dec
9
revised Cannot add witness to my mirroring setup
added 3569 characters in body