How do I build redundancy in sqlserver, I have sqlserver 2005 and 2008. I know we can build redundancy in mysql, and how do I build that in sqlserver. Any documents that I can read will be helpful.
asked May 03 '12 at 09:38 PM in Default
It depends on what you mean. If you mean that you want redundant data, you may want to evaluate carefully whether you really want that. Redundancy in data generally violates the normal forms and risks an inconsistency in your data in addition to storing more data and using more space.
Depending on why you want redundancy in data, there is almost always a better way to achieve the goal. For instance, if you are trying to protect against data loss than backups and log backups will help insure you do not lose data and provide point in time restore options. If you want redundancy for performance reasons then you are probably better off using more efficient, optimized queries or looking at indexed views
If you mean you want redundant hardware for high availability purposes then there are a variety of options depending on your exact needs. [Clustering] is in one option, but log shipping can also be used. I have also heard of replication being used for that purpose, though that is a bit of a stretch and can be somewhat awkward.
Hopefully this will help, but if this does not answer your question it might be helpful if you could expand the question slightly.: h ttp://msdn.microsoft.com/en-us/library/ms179530.aspx
OK, so you're looking for high availability. In that case, the technologies you should be considering and investigating are:
Which particular one you go for depends on your own requirements in terms of performance, cost, uptime, etc. There's a basic overview at SQL Server Central that applies to SQL 2005, and the rest of the first page or so of the appropriate Google search is also worth reading.
I would recommend Allan Hirt's book on the subject, Pro SQL Server 2005 High Availability.
answered May 04 '12 at 03:01 PM