What Changes In The Front End Code Is Needed If Mirroring Is Implemen

1.	What Changes In The Front End Code Is Needed If Mirroring Is Implemented For The High Availability?
Answer» You need to ADD only FAILOVER PARTNER information in your FRONT end code. “Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=AdventureWorks;Integrated Security=True;”. You need to add only FAILOVER PARTNER information in your front end code. “Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=AdventureWorks;Integrated Security=True;”.

What Changes In The Front End Code Is Needed If Mirroring Is Implemented For The High Availability?

Answer»

You need to ADD only FAILOVER PARTNER information in your FRONT end code. “Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=AdventureWorks;Integrated Security=True;”.

You need to add only FAILOVER PARTNER information in your front end code. “Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=AdventureWorks;Integrated Security=True;”.

Discussion

No Comment Found

Related InterviewSolutions

Explain The Different Types Of Backups Available In Sql Server?
What Is A Deadlock And What Is A Live Lock? How Will You Go About Resolving Deadlocks?
What Are Sparse Columns In Sql Server?
What Is Replication With Database Mirroring?
What Is Policy Based Management (pbm)?
What Is Service Broker?
What Are The Basic Functions For Master, Msdb, Model, Tempdb And Resource System Databases?
What Happens If We Start The Full Text Service On Passive Node.
Can You Move The Resources After Pausing The Node?
What Is The Status Of Services On Passive Node For Failover Cluster In Sql Server?

What Changes In The Front End Code Is Needed If Mirroring Is Implemented For The High Availability?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment