When I tried to restore a backup an error occurred showing access denied. The error message is as follows:
Restore failed for Server 'VAIO\sqlexpress'.
(Microsoft.SqlServer.SmoExtended)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\MSSQL10.MSSQLSERVER\MSSQL\DATA\ihrd_mvk_newspaperboy.mdf'.
(Microsoft.SqlServer.Smo).
Best Answer
Open "SQL Server Configuration manager"=>set "SQL Server" logon as=>Local System.