none
Backups failing on alwayson with "Directory could not be found error" RRS feed

  • Question

  • I am using Olla Hallengren's scripts to configure backups on a 2 node always on setup. A separate domain service account was created and access for it was given to the file share where the backups are supposed to happen. Thing is, the backups keep failing of the following error 

    Msg 50000, Level 16, State 1, Server --- , Procedure DatabaseBackup, Line 457  The directory \\infclus01fs\backups$ does not exist. 

    What could be wrong? Can some please provide any pointers? 

    Wednesday, November 2, 2016 7:15 PM

All replies

  • can you verify that this hidden share does exist. Go to infclus01fs and type net share. You should see the physical folder which hosts this share. Right click on it and select sharing to ensure that it exists.

    Also does your backup account have read and write access to this share?

    Wednesday, November 2, 2016 7:17 PM
  • Should that Service account be in the list in the security tab of the Fileshare properties(with read/write access)? I don't see it in the list at all... 

    Wednesday, November 2, 2016 7:51 PM
  • Hi buddinggeek,

    Based on the error message, this issue is caused by that the SQL Server Agent account do not have sufficient permission to the remote folder which contains backup files. You can use the following steps to add the permission:

    First, please open SQL Server Configuration Manager and then find the SQL Server agent Service, right click on it and select Properties, then please check the account you log on as.

    Second, you can add the permission to the remote folder by using the following steps:

    1.    Right click on the shared folder, click Properties, then in the Sharing tab, click Advanced Sharing.
    2.    Select Permission, click add, then enter the account to it and click OK.
    3.    Select Full Control in allow, click OK.

    It is as shown as below picture:
     

    Best Regards,
    Teige

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, November 9, 2016 7:44 AM
    Moderator