November 7, 2014 at 4:34 am
Hi Everyone,
I have configured mirroring with High availability with automatic fail-over(Witness is available). if primary server fails mirror server will up automatically. here how application knows about Mirror server. how the application will work without failure.
November 7, 2014 at 5:52 am
With SQL2008 (R2 ?) you'll need to modify your connection strings and add the failoverpartner parameter.
http://www.connectionstrings.com/sqlconnection/database-mirroring/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 7, 2014 at 6:37 am
ALZDBA (11/7/2014)
With SQL2008 (R2 ?) you'll need to modify your connection strings and add the failoverpartner parameter.[
assuming your chosen connection library supports the database mirroring parameters
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2014 at 7:23 am
Perry Whittle (11/7/2014)
ALZDBA (11/7/2014)
With SQL2008 (R2 ?) you'll need to modify your connection strings and add the failoverpartner parameter.[assuming your chosen connection library supports the database mirroring parameters
Indeed.
If your connection library doesn't support a failover partner, only your data will be high available if you still have to modify connection parameters for applications at fail time.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 7, 2014 at 8:04 am
How can we modify the connection string for SQL2008. we have to change it Web Server config file or is there any option in Mirroring.
November 10, 2014 at 12:45 am
what connection library are you using?
What's the content of your content file ?
( does it contain the full connection string or just parts of it)
Can you mail the connection string you are currently using ? ( don't include username/password info )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply