Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

DR setup for a customer server Expand / Collapse
Author
Message
Posted Friday, January 31, 2014 3:37 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 11:40 AM
Points: 258, Visits: 809
You also need a strategy/process for syncing up database logins between the two sites.
And if you use SQL logins, then you need scripts/processes that sync up the database users associated with those logins because of the different SIDs.

That said, Mirroring or log shipping are the obvious candidates.

You need to get detailed information on what the actual SLAs are with respect to down-time and data-loss.
You do not want to start designing your solution before you have all the requirements.
Post #1537013
Posted Friday, January 31, 2014 3:58 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
@arnipetursson +1 - The logins/SIDS completely slipped my mind, but shouldn't pose much of an issue considering they would physically be available to the DR site, you'd just need to "correct" them

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1537018
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse