Failover\standby database server

  • I have persuaded my company to invest in a SQLServer 2005 Enterprise Edition, they have also agreed to a standby\failover server (also enterprise edition) at another site. The software we will be hosting will not allow transactional replication. That (I think) leaves me with transaction log shipping and\or database mirroring which is the better option?  Thanks in advance

  • If you want an automated failover system then you want to use database mirroring.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply