I would like to set up a complete redundancy solution for a business database our company uses. This will include new server hardware and SQL
server replication between the two servers.
I would like to move the current live environment to a new server, and use the current as the redundant back up. I would also like SQL server
replication of the database between the two, to ensure the redundant server is completely up to date with the live one.
Can this be set up within SQL Server regardless of the database, or do the database tables have to have CLSID columns for example or any other changes? If it is possible, what needs to be done to make this happen?
I would also like to know if it will be possible to set up the clients to use a live server, but have a simple option of selecting the redundant one
if necessary. If so, how is it done?