Comments
1 comment
-
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>] ... " '
Add comment
Please sign in to leave a comment.
Step by step, how would I do this?