Mirroring SQL Server 2008 to a disaster recovery machine twice a day
I want to mirror my SQL Server 2008 to a disaster recovery machine two times a day. Is there any free software to do this on a running SQL Server? If not, are there any cheap alternatives? Can scripts be run to copy the files over while SQL is running? Can I use shadow copy for this?
ASKED:
Jul 21, 2010 1:59 PM GMT
UPDATED:
July 21, 2010 7:10:12 PM GMT
RELATED QUESTIONS
- Configuring a disaster recovery plan for Exchange Server 2007
- Setting up database mirroring for disaster recovery in SQL Server
- Replication and using EMC Autostart
- Best practices for backing up Exchange 2007
- SQL Server Failover Clustering or DB Mirroring
- Disaster Recovery
- Disaster recovery for SQL 2005
- SQL Server 2008 Restore Fails - There is insufficient system memory in resource pool 'internal' to run this query
- Creating clustered index on exiting table
- Bare Metal Restores Windows Servers
Answer Wiki:
There are a number of ways to do this that are all available from within SQL Server 2008.
- Database Mirroring
- Replication
- Log shipping
- Backup
Mirroring can be configured to enable automatic failover. The others involve manual failover or other activity
- Database Mirroring
- Replication
- Log shipping
- Backup
Mirroring can be configured to enable automatic failover. The others involve manual failover or other activity
2,260 pts.
To see other answers submitted to the Answer Wiki View Answer History.
