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![Stick Out Tongue :p :p](styles/default/xenforo/smilies/tongue.png)
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.
]]>