SQL Server Performance

db mirroring question

Discussion in 'Getting Started' started by lara99, Sep 24, 2009.

  1. lara99 New Member

    hi all in mirroring if i have multiple database set up , if one of the database goes corruptor failed, does the applicatoin connecting to that one applicatoin will failover or allthe application connectoin to server will failoverplease share the experiences.thanks,lara
  2. ghemant Moderator

    IMO it failover to secondary server
  3. satya Moderator

    You need to be careful if your application has dependancy of multiple databases for connectivity & funcationality. In this case only the database having issue will be failover to mirror server, but if there are such dependancies then application will have outage.

Share This Page