July 17, 2009 at 1:53 pm
if a principal server suddenly fails, if the mirror server has confirmation from the witness, it can automatically take on the role of principal and make its database available within a few seconds.Then that time i should get the alert mail.
For that i am preparing monitoring storedprocedure.
It means if i excute that sp then i should get the mail alert.
I am not able to implement this logic in that sp.
any help pls..........
July 17, 2009 at 3:04 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic754989-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply