Tuesday 27 May 2014

Unable to locate Database backup (.bak) file during Database restore.


Recently I was given a Database backup (.bak) file to restore database. In SQL Management Studio when I tried to locate the backup file, it was not visible to me.  



Problem was the permissions issue. SQL Server Service was running using 'Network Service' account but 'Network Service' account did not have permissions to access the backup folder. 

To check the current account of SQL Server Service. Go to Control Panel > Administrative Tools > Services and the double click on SQL Server Service. It will open properties, then click on 'Log On' tab to see the account used to Log on by SQL Server Service. Following picture shows the account used for service.



Now right click on Backup folder to open properties. Click on Security tab and then click on Edit.. 
it will open a new window  called 'Permissions for <folder-name>'. Click on Add and add Network Service and give full control and press OK to close both windows. 

  
Now restart the SQL Server Management and try to restore the backup again. Backup (.bak) file should be visible now. 

P.S. Hayer

Please check my other blog here: Hayer's MS Dynamics CRM Blog

1 comment: