Use Network Path to Store Maintenance Job - Backup

• Bisi Onaolapo

  Grasshopper

  Points: 17

  More actions

  March 21, 2015 at 12:45 pm

  #298910

  Hi,

  I set up maintenance job to back up a database and store it in a network path.

  I cannot see the file in the network path.

  Does SQL server allow network storage for backup maintenance job or I can only store in local drives.

  Thank you,

  Bisi.

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  March 21, 2015 at 5:30 pm

  #1785529

  You can backup to a network URL:

  \\MyServername\MySharename\MyFoldername\MySubfoldername

  The windows login that is running the maintenance plan must have permission to the write to the target folder.