Monday, March 12, 2012

Problem with restoring an SQL 2K backup on to SQL 2005

I am currently having a problem with restoring a backup made on SQL 2000 XP machine onto a Windows server 2003 machine with SQL Express 2005. I am getting 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\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