We help IT Professionals succeed at work.

Mirroring Backups in Sql 2000 to separate locations?

I have a SQL database and I'm trying to mirror to full backs into separate locations:  One will remain on-site and the other will be sent off-site via VPN.  So far I have only seen this done in SQL 2005, but unfortunately I only have version 2000.
Comment
Watch Question

Yes, Ive encountered the same limitation.  With 2000 it is not possible.  That functionality existed in pre 2000 editions and is back in 2005.  Not sure why it was missing in 2000.

Author

Commented:
Is there a work around for this?
David ToddSenior Database Administrator
BRONZE EXPERT
Commented:
Hi,

One method would be to backup to local disk, then back that up to tape, and next copy that backup file over the network.

HTH
  David

Explore More ContentExplore courses, solutions, and other research materials related to this topic.