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 |
|
mattk2006
Starting Member
1 Post |
 Posted - 2006-05-22 : 17:30:20
|
| Hi, This might be somewhat fundamental to you all but I really need to some feedback on this:We are running a number of data bases via SQL Server 2000. These databases are key to a number of clients that we have and are vital to daily operations.There are a number of ways to create redundancy by duplication. Namely, replication, clustering, SQL 2005 Mirroring, log shipping, and Third party solutions.. Clustering seems like the most obvious choice, however it can get expensive quick. Mirroring looks like the next best option but the way that it works requiring three computers seems like a bit of wasted resources (Witness system) and the fact that it requires SQL 2005.Ideally, we would like real time replication happening so in the event of a failure, the data is up still. With this being said, looking at a solution such as transactional replication, although the data may be automatically made redundant on another server, a failure is still not transparent to users nor is there any guarantee that all data entered will have made it into the data base before or during a failure.My question for you all is: What might be the best way to meet our goals of availability, cost effectiveness, and user transparency to failures?We are currently looking at a product that creates a virtual software cluster around the SQL transactions which basically takes your database servers and allows them to balance the load as well as provides availability. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-22 : 18:02:58
|
quote:
Originally posted by mattk2006...My question for you all is: What might be the best way to meet our goals of availability, cost effectiveness, and user transparency to failures?...
I think the best place for you to start is to identify what those goals actually are. As I am sure you are aware, an increase in availability and user transparency will drive up the cost and reduce cost effectiveness.If you identify what you want to do, you can then look at what it will cost and then decide what is really worth it to you.CODO ERGO SUM |
 |
|
|
|
|
|
|
|
Replication the answer?