• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1070
  • Last Modified:

Restore file from BAK error

I just received a sql backup file from what I believe is sql 2000.  when I select the file in the restore process I get this error.  I'm running SQL Server Express 2005 on my laptop.


Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Burrwolf_11142007.bak'. Operating system error 5(Access is denied.).
RESTORE FILELIST is terminating abnormally. (.Net SqlClient Data Provider)

Any help would be appreciated
thanks
0
keschuster
Asked:
keschuster
  • 3
  • 3
1 Solution
 
Chris MangusDatabase AdministratorCommented:
Error 5 usually indicates a lack of permissions to the file.  Can you verify that the account being used to restore the database has access to that directory?
0
 
keschusterAuthor Commented:
Sorry newbie here - where do I do that in 2005?
0
 
Chris MangusDatabase AdministratorCommented:
This would be outside of SQL Server.  When you connect to the SQL Server via SQL Server Management Studio, what account are you using, a SQL account or a domain account?

If a domain account, it will need at least read permission on your backup folder.  If you're using a SQL account when you connect then the account that your SQL Server uses to start up will need read permission to the folder.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
keschusterAuthor Commented:
I'm loggin in with my domain account (windows authentication),  everything is on my laptop.  I have full access to it - I copied it there.
0
 
Chris MangusDatabase AdministratorCommented:
Has the SQL Server service login account been changed recently?

I would try adding the SYSTEM user with full permission to your backup folder.

Also, check this link for more info as I am leaving my computer for the day...:  
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=283827&SiteID=1
0
 
keschusterAuthor Commented:
That was it.  Once I have the system user more permissions I coulde read the file.  That link was perfect
thanks
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now