"System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Avidian Technologies\Prophet\avidian.mdf'. (Microsoft.SqlServer.Express.Smo)"
I'm not sure what is going on becuase I have no issues installing the backup on my XP Pro machine that has SQL Express 2005 Dev edition. So what I did was restore the backup on to SQL Express 2005 on my dev machine and backup again. Unfortunately when I took the newly created backup and tried again to restore the database on to my window server 2003 machine it failed again. Exact same message was displayed.
Any suggestions or help would be greatful.
Thanks,
Rodney
Rodney, here is a thread on the engine forum regarding this issue. It looks like they solved it. Can you read through it and see if it works for you?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=169145&SiteID=1
Thanks,
Sam Lester (MSFT)
No comments:
Post a Comment