SQL Server Restore Error - Access is Denied

sql-server sql-server-2005 backup restore
cdub picture cdub · Aug 11, 2011 · Viewed 168.3k times · Source

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?

Answer

Exile picture Exile · Jun 17, 2013

I have just had this issue with SQL Server 2012.

It turns out all I had to do was tick the box marked 'Relocate all files to folder' on the 'Files' section:

enter image description here

(Click to see image full size)

This of course assumes you have the correct version of SQL Server installed.

Related questions

When restoring a backup, how do I disconnect all active connections?

My SQL Server 2005 doesn't restore a backup because of active connections. How can I force it?

Read More
Restore database backup over the network

How do you restore a database backup using SQL Server 2005 over the network? I recall doing this before but there was something odd about the way you had to do it.

Read More
How to backup SQL Server Agent jobs?

How can I backup and restore SQL Server 2005 Agent job schedules?

Read More