Most of people uses Ola Hallengren’s Maintenance Solution to administer their databases. It’s easy to setup, easy to maintain. It also has dozens of parameters that you can specify and adjust maintenance plan according to your business needs.If you never heard it, you must take a look now!
We have encountered a generic problem with backup script, it was complaining about network share that we take our database backups.
We use same script on each instance, so script is good.
File share is accessible from that database host, network access is good.
We gave read/write permissions for SQL Agent service account for backup folder.
Still we get this error, so what is the problem?
The directory “\\fileshare\Network Backup Folder” does not exist. [SQLSTATE 42000] (Error 50000)
SQL Agent service account is not enough!
Both SQL Server (database engine) and Agent service accounts should have access on backup folder. Indeed after giving permissions for SQL Server service account and rebooting hosts to clear windows policy cache( if you forget to reboot or logoff/logon you will be asking WHY question a lot) it started to take backups.
Summary: If you see SQL Server can not reach a network share directory for backup or another reason, first check that both service accounts have access to that folder, then either reboot the host or log off and log on with that accounts.
Bahti Samet Coban 