Restoring failed

Question

Restoring failed

m.rajesh.uk

Hall of Fame

Points: 3653
More actions
June 24, 2013 at 3:19 am

#276638

Hi all,
When i am trying to restore a database with the backup i am getting this error
06/24/2013 14:30:54,spid59,Unknown,The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\IPE_OCT_120_log'.
06/24/2013 14:30:54,spid59,Unknown,Error: 3634<c/> Severity: 16<c/> State: 1.
i am unable to figure it out.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

HanShi SSC-Dedicated Points: 33507 More actions · Answer 1

It looks like the folder 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\IPE_OCT_120_log' doesn't exist or the SQL service account doesn't have read/write access to that folder.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

m.rajesh.uk Hall of Fame Points: 3653 More actions · Answer 2

how to give permissions to service accounts. how to check what permissions the existing service account have. can any one throw some light on it . any useful material.

HanShi SSC-Dedicated Points: 33507 More actions · Answer 3

Changing permissions on a folder is done from within Windows. You can use the Windows Explorer and open the properties of the folder. Use the security tab to add accounts and add/change permissions.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

m.rajesh.uk Hall of Fame Points: 3653 More actions · Answer 4

i am not able to see any service accounts in security ... can any one give further more details.

Dird SSCertifiable Points: 5081 More actions · Answer 5

See which account the SQL Server process is run as. Grant privileges to that one.

Dird

SQLAli Ten Centuries Points: 1109 More actions · Answer 6

Please follow the below procedure.

Open SQL Server configuration manager

Check the service account

Browse the appropriate folder where backup file exists

Open the properties of server then click on security tab

Add the service account and provide the read write permissions.

Thanks,
I’m nobody but still I’m somebody to someone………….

m.rajesh.uk Hall of Fame Points: 3653 More actions · Answer 7

i cant see any service accounts i can see only domain user accounts there. do we need to add service acount in security tab

SQLAli Ten Centuries Points: 1109 More actions · Answer 8

Is backup path accessible from the server where you are restoring?

Thanks,
I’m nobody but still I’m somebody to someone………….

HanShi SSC-Dedicated Points: 33507 More actions · Answer 9

m.rajesh.uk (6/25/2013)
i cant see any service accounts i can see only domain user accounts there. do we need to add service acount in security tab

The user account that is used to run a service is referred to as a "Service Account". A service account is NOT an account you will find literally in AD or a user list.

Grant the domain account that is used to run the SQL Service (see steps in the post from 'sweetmoulali') the read/write permissions on the folder.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **