Which replication method is best for SQL Server Disaster Recovery scenarios?
Posted on 2010-11-25
We're looking at setting up a 'clone' of an ERP server in a remote site for DR purposes. This is only to be used in the event of the main server going down. There is a front end server which accesses the database server. Installations of both have been done at the DR site.
The question is, which is best for replicating the databases to the DR site - SQL Replication or SQL Mirroring? We've noticed that SQL Replication seems to generate massive log files on the DR server meaning that we have to keep a constant eye on it.
In the event of a disaster, we'd use the DR servers and then go back to the main servers once they are up and running again. The thought being we could replicate or mirror back again the data changes.
Any suggestions welcome!