Options

Backup to network or remote drive

JOakley77JOakley77 Posts: 2
edited December 1, 2007 5:22AM in SQL Backup Previous Versions
I would like to back up to an off site drive but cannot determine how to map or other push to this drive.

Step by step, how would I do this?
· Share on Twitter

Comments

  • Options
    peteypetey Posts: 2,358 New member
    I guess you are referring to a remote drive.

    - the SQL Backup Agent service startup user needs to have read/write rights to the remote drive.

    - when you back up to the remote drive, use the UNC naming convention e.g.
    EXEC master..sqlbackup '-sql "BACKUP .... TO DISK = [\\remoteserver\backups\<AUTO>] ... " '
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.