Post reply

Database Mirroring

  • July 17, 2009 at 10:42 am

    #207097

    (If principle database gows down then mirror database takes the charge.

    Then that time i should get the alert mail with both databases status.)

    I need the sp for this(using above logic).I am using dbmail.

    thanks in advance...:-)

  • July 17, 2009 at 11:03 am

    #1026333

    If the principal goes down, then you may or may not be able to get a mail.

    http://msdn.microsoft.com/en-us/library/ms408393.aspx

  • July 17, 2009 at 11:50 am

    #1026363

    Thanks steve,

    I want to prepare the StoredProcedure for minitor mirrored databases.

    It means i should get the alert mails when the mirror database takes the charge.

  • July 17, 2009 at 1:29 pm

    #1026407

    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 1:30 pm

    #1026409

    http://msdn.microsoft.com/en-us/library/cc966392.aspx

    I think you want an alert on mirroring state 8.

  • July 17, 2009 at 1:49 pm

    #1026423

    yes.

  • July 20, 2009 at 4:18 am

    #1026839

    i want to store the database mirror state changes in table ,

    can u pls give the query?...............i want to do this through T-sql statements not through GUI.

  • July 20, 2009 at 12:47 pm

    #1027244

    You should be able to set up the alert based on the scripts in that link. The alert can be set to generate the emails you need, and can also run another job which in turn can execute a stored proc to produce whatever information you want to save. You could look at sys.database_mirroring for the state of each database.

  • July 21, 2009 at 8:37 am

    #1027665

    thanks its completed.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply