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
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.