07-31-2023, 08:44 AM
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?
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?