MS SQL DB 복원시 Access is denied.오류 발생시

SQL Server 2008 R2를 복원시 Access id denide가 나타난다면,

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'.

 

 

Relocate all files folder를 선택해서 복원된 폴더를 바꿔주면 성공적으로 복원이 된다.

 

출처: https://stackoverflow.com/questions/7031792/sql-server-restore-error-access-is-denied