[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • Last Modified:

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.
0
ldcray
Asked:
ldcray
2 Solutions
 
BillPowellCommented:
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.
0
 
ldcrayAuthor Commented:
Is there a work around for this?
0
 
David ToddSenior DBACommented:
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
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now