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.
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