SQL Server Performance

Notify for 1st Failover Event

Discussion in 'SQL Server 2005 Database Mirroring' started by Zakir, Nov 3, 2006.

  1. Zakir New Member

    Hi all,
    When we setup an alert based an a WMI event -- such as the failover of a database, an alert is created for database failover. Since we have more than 20+, this means that the DBA would be paged 20+ times for one server failover. While I could setup the alerts based on only one database -- this would be assuming that all databases failover together -- which they might not if something goes wrong, such as if somebody fails over one database by accident but not others. Is it possible to set the alert so that it only pages our DBAs once, for the first database that fails over, instead of for every database?
  2. satya Moderator

    Are all the databases are linked to each other by any way?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. Zakir New Member

    They're linked in that they're all necessary for a certain application. However, they are not linked within sql server. The solution that I came up with was that I created a job that pages us if the databases are not set to primary on the same server and then picked one of the central databases for mirroring pages... so if one database is failed over by mistake, it will page us concerning a database split rather than all the databases failing over.
  4. satya Moderator

    If you are based on automatic failover, can you set specific databases for manual failover. This way you can reduce the issues of pager.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  5. Zakir New Member

    I'm not sure that I completely understand. I need all of the databases to fail over automatically since one application was designed around several of them.

Share This Page