SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Sever Setup
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

supersql
Yak Posting Veteran

99 Posts

Posted - 01/18/2009 :  11:50:07  Show Profile  Reply with Quote
Here is the setup am thinking of , let me know if that is a gud idea. May be again thinking of clustering.

I do have 6 servers and only 1 instance on each. each server may have nearly 10 big sql 2005 databases each db of about 700GB on an average.

Dev1 Dev2 Dev3 Dev4 Dev5 StageDev
db1 db11 db21 db31 db41 db5
db2 db12 db22 db32 db42 db8
. . . . . db21
. . . . . db27
. . . . . db32
db10 db20 db30 db40 db50 db45

all these servers will be under one name called " DEV" like clustering have 6 nodes. To acheive my purpose i want to update/load data in StageDev\db8 and once update is done for StageDev\db8 then failover(take offline) just one db Dev1\db8 and bring StageDev1\Dev8. I n this process the end user should not be noticed that he was switched from Dev1 to StageDev. Ofcourse 30min downtime may be accepted in this scenario.

I am not sure if this setup will workout. If this can be done in that case what hardware/software is needed to make it run smooth.

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 01/18/2009 :  12:33:16  Show Profile  Reply with Quote
You should use Database Mirroring for it.
Go to Top of Page

supersql
Yak Posting Veteran

99 Posts

Posted - 01/27/2009 :  17:58:49  Show Profile  Reply with Quote
Hows that possible? I dont want to share resources between the servers like CPU,RAM etc. I am trying to get rid of downtime when users do heavy data load job so that other users can actively work on the servers.
thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000