Error while checking the back up file corrupted or not

Question

Error while checking the back up file corrupted or not

SQL Prog

SSCrazy

Points: 2020
More actions
May 23, 2012 at 11:05 am

#145368

I am working on Microsoft sql server 2005 version. I am trying to restore the database from the back up files stored in different server. I am getting error when trying to restore.During debugging process I was thinking to check the back up file whether it is corrupted or not by using
RESTORE VERIFYONLY FROM DISK = '\\ServerName\FromINTLQ01\043112\POSTEOM_Service.bak'
But I am getting an error as
Cannot open backup device 'E:\FromINTLQ01\043112\POSTEOM_Service.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally. But I can navigate to the path mentioned and see the back up file. I chedcked all the permissions and I am logged in as windows authentication and I have full permissions to the folder mentioned. Please help.

Viewing 7 posts - 1 through 6 (of 6 total)

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

Steve Jones - SSC Editor SSC Guru Points: 735712 More actions · Answer 1

This has nothing to do with your permissions. It has to do with the permissions of the service account running SQL Server. That account needs to be able to see the folder.

SQL Prog SSCrazy Points: 2020 More actions · Answer 2

Thanks for your reply. Service account you mean sa?...I am not using sql server authentication to login..I am using windows authentication..Could you please help me understand how to see the sql server account that has permissions to that shared directory..Please help...

Thank You

Steve Jones - SSC Editor SSC Guru Points: 735712 More actions · Answer 3

Not login, service account.

SQL Server runs as a service (control panel | services, or Configuration Manager). The account that runs SQL Server is what accesses the backup file.

SQL Prog SSCrazy Points: 2020 More actions · Answer 4

Please help me in understanding how to know on which account sql server is running...

Steve Jones - SSC Editor SSC Guru Points: 735712 More actions · Answer 5

Look in the Configuration Manager. This is an application running on the server. That's what I referenced in the last post.

If you don't understand that, please use Books Online to help. If you don't understand what a service is, then you need to do some research on what a Windows service is.

SQL Prog SSCrazy Points: 2020 More actions · Answer 6

Thank you so much. I will cross check the permissions of service account