SQL 2005 mirror or log shipping?
Posted on 2007-11-16
Having trouble, lots, doing a SQL 2005 backup job from one W2003 server to another, secondary W2003 server with ~3GB of data. The secondary server is simply for DR and will not be used unless the primary server fails.
I think either mirroring or logshipping would achieve the desired result. I'm inclined to pick the least complex implementation & operation solution. Maybe there are others worth considering?