Home > DeveloperSection > Forums > SQL Server Restore Error - Access is Denied
Allen Scott

Total Post:46

Posted on    September-08-2015 6:56 AM

 MSSQL Server MSSQL Server 

 0 Reply(s)
 676  View(s)
Rate this:
I created a database on my local machine and then did a backup called tables.bak of table DataLabTables.

I moved that backup to a remote machine without that table and tried to do a restore but get the following error:

System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DataLabTables.mdf'.
How do I fix my rights, if that is the problem?

Don't want to miss updates? Please click the below button!

Follow MindStick