Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-08-06 : 01:40:32
|
| Dear Experts,You are Expert DBA's with Great experiences. actually how many servers needed for an emergency organization to run with out a single minute downtime? purchasing servers is not a problem.the existing scenario in my organization is two servers are there one is 006 and other is 007. we configured transactional replication between these.the applicaiton is windows based application and around 150 clients connects to 006 and this is a 24X7 environment.if some thing goes wrong with 006, we need to change all the 150 systems configuration to 007. this will take around 3 hours downtime.i've been thinking of Databse Mirroring (because of automatic failover)between 006 and 007. but here the problem is we can not query from 007 in mirroring.so i'm thinking of taking another server and configuring mirroring between 006 and the new server(may be 008). and 007 as witness server.i've all these confusions. please provide me a good strategy for my environment.thank you very much.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-06 : 08:18:36
|
| Why don't you do clustering and asynchronous database mirroring between 06 and 07? There is no hard and fast rule that there should be no downtime. When disaster strikes,all company can understand it.Or Use Geographically distributed Clustering(But it is way- way expensive). |
 |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2008-08-06 : 10:09:59
|
| Sounds like it's a very important situation. I am very surprised that any organisation that needs this sort of reliability has employed someone who is so naieve that they go to a web site to find the answer. If money is no object for servers then why not spend some of that money on expert advice?To achieve what you want is very complex and it would be impossible to give you an answer on a web forum. There is so much to consider - Storage - is it all on a SAN? Is it replicated? Is there a copy offsite? Is 30 seconds downtime acceptable? If not,why not? What about upgrades to the software? What about OS/Server patches? Why do you think your configuration needs to change when you swap over? Seriously - it's complex. With no disrespect to those on this forum, pay an expert to assess your situation in the context of your environment. There are no off the shelf solutions based on the info available. |
|
|
|
|
|
|
how many servers needed