Home Forums SQL Server 2005 Backups Operating System error 5(Access is Denied) RE: Operating System error 5(Access is Denied)

  • Hi,

    i'm also having same problem..

    Here is the error , which i get while i attempt to restore my database:

    restored failed for server 'Horizon\sqlexpress' (Microsoft.SqlServer.Express.Smo)

    Additional Information:

    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\Data\exper35_ExpertZoo.ldf' (Microsoft.SqlServer.Expres.Smo)

    I have attempted un-checking the ReadOnly attribute from the files and folders on this path. But, ReadOnly attribute of folders gets back to Checked as soon as i remove it. I attempted the procedure given here to permanently uncheck this attribute But it can work only for files, not folders.

    Can anyone please help me in this regard? I'm simply stuck on this issue.

    Thanks in advance