Backup SQL Server Databases to Network Share Drive

Overview

• Topic: Backing up SQL Server databases to a network share drive.
• Common issue: "Access Denied" error when attempting to back up despite shared folder being mapped.

Troubleshooting Steps

In a Domain Environment

1. Grant Permissions:
   • Provide read and write permissions for the SQL Server computer account to the shared folder.
2. Grant NTFS Permissions:
   • Ensure SQL Server computer account has NTFS permissions on the shared folder.

In a Workgroup Environment

1. Create User:
   • Create a user on both SQL Server and file share server with the same username and password.
2. Set Permissions:
   • On the file share server, add both share and NTFS permissions for the newly created user on the shared folder.
3. Change Service Account:
   • Change SQL Server service to run under the newly created user.
4. Restart SQL Service:
   • After making the above changes, restart the SQL service.

Conclusion

• Follow these steps to resolve access issues when backing up SQL Server databases to a network share.
• Thanks for watching! See you in the next videos.