SQL Server 2000 Disaster Recovery
Posted 06 April 2009 - 08:51 PM
Posted 09 April 2009 - 06:07 AM
I have several database systems running on MS SQL Server 2000 and would want to find out how if there is any tool or software that l can use for SQL Replication to a remote server. There is one with SQL Server 2000 but its currently giving me problems. All l want is to have another server that will maintain an exact copy of the Production Server updated periodically so that i case of a disaster very little data will be lost.
I'm am using Symantec NetBackup to perform these tasks, however you might be concern of the cost of client licenses as well.
Hope it helps.
Edited by xpthinker, 09 April 2009 - 06:07 AM.
Posted 19 May 2009 - 07:17 AM
you can use sql tool like Setting up Transactional log shipping , which will require a quite bandwith depending on your database size.
You can also use Double Take software (I will recommande you that, be cause it's include metadata while replicating).
i hope this will help.
Posted 31 October 2009 - 03:32 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users