June 10, 2014 at 5:29 am
Hi,
I am having difficulty restoring my database backup from a network location.
So far I have tried to do the following:-
RESTORE DATABASE TestDB
FROM DISK = '\\test-backup\test1\test2\TestDB_backup_201406101135.bak'
WITH NORECOVERY;
However it shows the following error:-
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device '\\test-backup\test1\test2\TestDB_backup_201406101135.bak'.
Operating system error 5(error not found).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I know I have permissions for my SQL Login on this remote servers.
I also tried to run as administrator for SSMS but it's still showing the same error as above.
Any help most appreciated.
Thanks.
June 10, 2014 at 5:34 am
It's not about the permissions you have. You need to make sure that the SQL Server service account has read permission on the backup location in order to do the restore. If SQL Server runs under a local system account, it won't work.
John
June 10, 2014 at 6:10 am
Yep, John has nailed it. I'd add a +1 if we had that capability here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 10, 2014 at 6:34 am
Ok I will check that thanks.
I have also tried to restore by adding my .bak file onto a folder on the C drive locally.
When I try to do a restore via SSMS gui or script the .bak file is simply invisible!
I can see it via Windows Explorer though so it's definitely there.
I have checked permissions on the folders and have added in the SQL Server service account in and given full control but still nothing.
My account which I'm logged in as also has full control on the folder.
June 10, 2014 at 6:45 am
zedtec (6/10/2014)
Ok I will check that thanks.I have also tried to restore by adding my .bak file onto a folder on the C drive locally.
When I try to do a restore via SSMS gui or script the .bak file is simply invisible!
I can see it via Windows Explorer though so it's definitely there.
I have checked permissions on the folders and have added in the SQL Server service account in and given full control but still nothing.
My account which I'm logged in as also has full control on the folder.
Check the permissions on the .bak file itself. In particular, I'm thinking that the owner of the file is the login used to create the backup in the first place. If the user your using doesn't have permissions to the backup file, SSMS doesn't show it to you. If you have permissions on the box, you can add the user to the permissions list for the file.
June 11, 2014 at 3:00 am
Ok thanks.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply