December 11, 2009 at 5:28 am
I have a database running on server1.
server2 and server3 look at server1 as a linked server, and access objects on it via synoynms stored on server2 and server3.
server1 is becoming v important to the organisation so I am considering mirroring it to help with any recovery. My question is if it was mirrored onto server4, woudl I have to repoint my synonyms on servers2&3 to server4 in the event of failure? Have I implemented a really poor architecture in doing this?
(I have the same problem with a number of fat client apps that also look at server1 accessing its details from a connection string in a registry - so I may have to go and change these in the event of switchover as well).
Hope someone can offer some advice
Thanks,
Andrew
December 11, 2009 at 6:48 am
andysfreeemail (12/11/2009)
My question is if it was mirrored onto server4, woudl I have to repoint my synonyms on servers2&3 to server4 in the event of failure?
Yes you need to have Linked Server on Server4 pointing to Server2 and Server3. Also a quick question, do you have only database that is on Server1 or multiple databases, just to remind, you need to mirror the rest of them too to Server4 (If your databases on S1 are interdependent)
Have I implemented a really poor architecture in doing this?
I personally don't think this is a poor architucture unless some more info, for what are you using the Linked Server S2 and S3.
(I have the same problem with a number of fat client apps that also look at server1 accessing its details from a connection string in a registry - so I may have to go and change these in the event of switchover as well).
I am no expert in that area, hope someone else replies.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply