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

Dr Server Implementation in sql server 2008 Expand / Collapse
Author
Message
Posted Tuesday, March 5, 2013 2:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:11 AM
Points: 71, Visits: 318
Hi,
i have morethan 100+ database in single instance but now i have plan for create Dr site server.
is it possiable for all database in Dr site..?
how can i do it..?
Post #1426654
Posted Tuesday, March 5, 2013 3:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 12:34 AM
Points: 1,143, Visits: 1,585
With a lot of effort
Post #1426684
Posted Tuesday, March 5, 2013 5:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:11 AM
Points: 71, Visits: 318
S yar but how to complete the task..?
Post #1426765
Posted Tuesday, March 5, 2013 10:39 AM


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,860, Visits: 7,130
Of course it is possible, for DR site you should have mirrored hardware (the same) - so if you can put 100 DB's on your production site, you should have no issues putting 100 DB's on your DR site.

What will your method of getting the DB's over there and keeping them in sync? Log shipping? 3rd party software? Etc?


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1426936
Posted Tuesday, March 5, 2013 11:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 205, Visits: 2,016
Storage replication (i.e. EMC SRDF) would be the easiest way of not worrying about 100 databases individually. Or you could write a custom log shipping routine that takes care of multiple db's at a time. That could be a lot of work, if there are different recovery objectives among all of the databases, meaning some logs get backed up every 15 minutes, some hourly, etc.
Post #1426954
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse