0

I am trying restore a SQL database from my SQL Server to a fileshare on another server. I keep getting access denied (unable to open the physical file) message during the restore.

In short, I am trying to restore a backup to a network file share.

I have a server SQLSRV (SQL Server 2017; Windows 2012 R2) and FILESRV (Windows 2012 R2). Each night I run an automatic back of database A and restore to database B. Both databases have been on SQLSRV. I just relocated the database B files to a fileshare on FILESRV. With database B on FILESRV I have been able to attached, query, update, backup to SQLSRV and FILESRV without issue. It appears the only thing I can't do is restore a backup from SQLSRV to FILESRV. It indicates it's a permission problem, but I have set Full access to Everyone and both the Share and NTFS. I have run ProcMon on FILESRV while trying to backup. I see the file open request and it shows as successful. I feel like I am overlooking something obvious, but I am at a loss.

Improve this question
3
  • 1
    I'm pretty sure the file needs to be on the local file system. Commented Jul 29, 2019 at 17:28
  • 2
    Possible duplicate of Restoring a database from .bak file on another machine Commented Jul 29, 2019 at 17:35
  • @Renat the referenced duplicate question appears to be trying to restore files from a network share to the SQL server. I am trying to restore files to a network share. Thanks Commented Jul 30, 2019 at 14:35
Related questions
52
Restore database backup over the network
2
restoring database
0
how to take backup to a network share?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.