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.

JeffreyPMc
  • 3
  • 2
  • 1
    I'm pretty sure the file needs to be on the local file system. – alexherm Jul 29 '19 at 17:28
  • 2
    Possible duplicate of [Restoring a database from .bak file on another machine](https://stackoverflow.com/questions/13396027/restoring-a-database-from-bak-file-on-another-machine) – Renat Jul 29 '19 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 – JeffreyPMc Jul 30 '19 at 14:35

0 Answers0