What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
- 1 Answers
- 1098 Views
- I also Faced
- E-Mail Answers
Answer Posted / Manoj Kumar Kushwaha
For implementing mirroring in SQL Server, changes to the front-end code are typically not required. However, you should ensure that your application can handle automatic failover and reconnection to the new principal server when a failover occurs. This may involve implementing connection string logic that accounts for multiple servers and dynamically switches connections based on the current principal server.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between openrowset and openquery?
How to rebuild the master database?
How do I create a trace in sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Explain “row_number()” in sql server with an example?
What is self contained sub query?
How to convert character strings into numeric values?
How do I find query history in sql server?
What is sql or structured query language?
what is spatial nonclustered index
What is acid mean in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How do I start sql server 2017?
How raid can influence database performance?
