Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: SQL Server Remote Back-Up

    What is the best way to back up sql server to a remote site so that if we had total data loss locally I would be able to restore and get back up and running as quickly as possible. I have a remote file storage option that I use and I currently store a MSAccess version of the db there. I assume there is a much better solution to this. Can someone "upgrade my knowledge" please?

    Thanks a ton~

  2. #2
    Join Date
    Jun 2005
    After the backup is complete, you could copy the .BAK files to the external storage server with a .BAT scheduled on windows.
    I'm not sure if sqlserver2000 can do this inside the Maintenance Plans


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts