I was attempting to use Ola Hallengren's scripts to backup to a remote NAS, but it was failing and not giving any direct errors, so I tried doing it manually using Server Management Studio and got the following error:
TITLE: Microsoft SQL Server Management Studio
——————————
Failed to retrieve data for this request.
(Microsoft.SqlServer.Management.Sdk.Sfc)For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476——————————
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)——————————
The operating system returned the error '0x80070005(Access is
denied.)' while attempting 'SvlPathDoesPathExist' on
'\Dl-nas-01\LOCAL FILE BACKUP\OLASQL'. The statement has been
terminated. (Microsoft SQL Server, Error: 3634)For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=14.00.2002&EvtSrc=MSSQLServer&EvtID=3634&LinkId=20476
Now, the account I am signed into has FULL permission and access to that share, my connection is my domain\myaccount, and from the VM I can even put \\Dl-nas-01\LOCAL FILE BACKUP\OLASQL into a folder browser and access it.
Does SQL Server run these from a different account I don't know about? Backing up to a local location works fine, what's the solution? I'm pretty lost.
Best Answer
You mentioned this is a NAS, but this doesn't look like a valid network path:
Try using two slashes at the beginning, like this: