April 22, 2020 at 10:23 am
I have few questions about Microsoft SQL Server database Mirroring.
Fail over of database is Automatic or Manual in case of Microsoft SQL database mirroring?
In case of failure in Primary database how new application requests will be routed to secondary database? Is it automatic or Manual? Do I need to make any change in application to connect to Secondary database or not?
How will I configure the application connection string in case of Microsoft SQL Database Mirroring? please share some example string.
Can I implement mirroring for a database that is already a snapshot replica of another Microsoft SQL database?
I am planing to use SQL Server 2014 for mirroring
April 23, 2020 at 11:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
April 23, 2020 at 2:20 pm
Have you read this? https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server?view=sql-server-ver15
It answers most of your questions. This can be automatic or manual. Clients move and are configured according to: https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/connect-clients-to-a-database-mirroring-session-sql-server?view=sql-server-ver15
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply