Problem when Restoring database

Posted by Vanchi050585 under Sql Server on 3/14/2011 | Points: 10 | Views : 1693 | Status : [Member] | Replies : 2
hi all,

when i restore my database the below error will come. please let me know what is the problem

error is:

System.Data.Sqlclient..Sqlerror: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargerForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\Sharpya.mdf'. (Microsoft.Sqlserver.Express.Smo)

please anybody tell the solution..

Thanks in Advance

Thanks
tvn



Responses

Posted by: Akiii on: 3/14/2011 [Member] Bronze | Points: 25

Up
0
Down
It is a permission Problem, please check your login credentials....
Try to login with the admin credentials.
Let us know if it is resolved !

Thanks and Regards
Akiii

Vanchi050585, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikanbarasan on: 3/15/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
HI,

This is Permission issue you need to have read, write and full access to the database. Check if you have these permissions and then try to restore the same...

Thanks
Karthik
www.f5Debug.net

Vanchi050585, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response