I created a database on my local machine and then did a backup called
tables.bak of table
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 FilesMicrosoft SQL ServerMSSQL.1MSSQLDataLabTables.mdf'.
How do I fix my rights, if that is the problem?