May 14, 2008 at 2:35 pm
Hello,
I am getting an error when trying to restore a SQL Server .BAK into a SQL Server Express database:
Restore failed for Server 'pb003070\sqlexpress'.
The operating system returned the error 5 (Access denied.) while attempting 'RestoreContainer::ValidateTargetForCreation on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\PBC.mdf'.
Any tips why this might happen?
Thank you,
Paul
May 14, 2008 at 10:03 pm
I have solved my problem.
Thanks,
Paul
May 15, 2008 at 11:30 am
Please share your solution
May 15, 2008 at 11:57 am
Well, my solution was to restore it into a SQL Server 2000 database, instead of SQL Server Express.
So, no real clever T-SQL here.
Sorry.
Thanks,
Paul
July 15, 2008 at 2:35 pm
You are getting error because the SQL User through which the SQL Service is running does not have write permmision on file system and your file system is NTFS (Any Version). In this case you can do the restore process by following these steps.
1. You can grant permission for writing into the file system for the SQL Service user or
2. You can configure your SQL Server service running configuration by changing it as 'login as User' mode.
but Running as a User can create problem sometimes (security reasons) because user account may have more previledges then the SQL Server account through whihc SQL Service is running. Here is the fix for this issue.
You can specify a location into the file system where 'Everyone' have full access to write or give write permission to the SQL Server user into the file system. After finish this file/folder permission step, restart the restore process you will able to restore your database. 😎
-----
Praddy - Yours Genuine Ally
http://pradeepkrsharma.spaces.live.com[/i%5D
[font="Verdana"]------
Praddy - Yours Genuine Ally,
https://www.pradeepkrsharma.com[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply