Problems with Restoring a SQL 2K db | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problems with Restoring a SQL 2K db

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 FilesAvidian TechnologiesProphetavidian.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
does the path exist?
Access is denied means the account used to restore the database doesn’t have privileges to write the files on specified path. Make sure the SQLagent account or SQL Services account has required privileges to do so. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Thanks Satya that worked after I added the privilege.
How does one add the priv on Windows XP Pro?
Custom Software
Database Design
MS Access to SQL Conversions
On XP Pro you need to check whether that user is a part of Administrators group. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>