SQL Server map network drive for backup

_{Sunday, January 14, 2018 10:41 PM}

I  am in process of setup SQL Server  native  backup\ restore setup network share.  Login user as all  rights on the network location. But through SSMS I cant access the network location. 

Backup error.

+++++++++++++

_{Monday, January 15, 2018 2:30 AM ✅Answered}

Hi ashwan,

>> Login user as all rights on the network location. But through SSMS I cant access the network location. 

SQL Server backups run in the context of the account that is running SQL Server, it is not the user you are logged in as but the account SQL Server service runs as. Please check to see whether your SQL Service account has access to the share. For more detailed information regarding SQL Server backup & restore to network shared drive, please refer to this blog.

If you have any other questions, please let me know.

Regards,

Hannah

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.

_{Monday, January 15, 2018 4:29 AM ✅Answered}

Error 5 = Access denied; as Hannah wrote, the SQL Server service account don't have write permissions on the share.

Olaf Helper

[ Blog] [ Xing] [ MVP]

_{Monday, January 15, 2018 6:00 AM ✅Answered}

https://blogs.msdn.microsoft.com/varund/2009/06/04/backup-and-restore-sql-server-database-to-a-network-shared-drive/

EXEC xp_cmdshell 'NET USE'
EXEC xp_cmdshell 
    'NET USE H: \10.0.0.0\SHAREDFOLFDER /USER:user /PERSISTENT:yes'

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

_{Sunday, January 14, 2018 10:53 PM}

try first cmd with admin right net use Z:\sqlbackup

Try use share path with hostname.

https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx

_{Thursday, January 18, 2018 8:07 AM}

Hi ashwan,

Any update? Is this issue resolved? We are looking forward to your response.

If you have any other questions, please let me know.

Regards,

Hannah

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.