How can we help you today? How can we help you today?

Backup to network or remote drive

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?
JOakley77
0

Comments

1 comment

Sort by
  • petey
    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>] ... " '
    petey
    0

Add comment

Please sign in to leave a comment.