Red Gate forums :: View topic - Can't restore database from SQB file located on mapped drive
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Can't restore database from SQB file located on mapped drive

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jdholman



Joined: 01 Oct 2010
Posts: 3

PostPosted: Fri Oct 01, 2010 4:49 pm    Post subject: Can't restore database from SQB file located on mapped drive Reply with quote

Hello:

I am on Red Gate Backup version 6.4.0.56 on SQL 2005. I have my backup files on a hiddne network share that I have access to via a mapped drive. I am using the same account to authenticate onto the server and on the Red Gate Backup service.

When I try to restore a database by browsing for a backup file, I can browse and select the file, but the file shows up in the file selection box in the Restore Wizard with a red "X" box in the "OK" field. The error there says something like:
X:\Roswell\FULL_(local)_DYNAMICS_20100924_210032.sqb does not exist
In the filename box the filename itself is prefixed with "unavailable"

If I cope the file to a local drive, I can restore just fine, but this isn't an option for the larger backup files.

Running this command:
EXEC master..sqbdir '\\de08w2767\enrafgpbak$'

Gives me this error:
Msg 1, Level 16, State 1, Line 0
<SQBERROR>782

What can I do to troubleshoot this?

Thanks in advance,

Jim
Back to top
View user's profile Send private message
jdholman



Joined: 01 Oct 2010
Posts: 3

PostPosted: Fri Oct 01, 2010 6:59 pm    Post subject: SOLVED Reply with quote

I figured this out and am posting what worked for me.

When you click "Add Files", you must click "Add Server" and enter the remote server name and browse the files that way. It isn't enough that you have permission and have mapped a drive letter. You need to add the server, browse the server in the tree, and select the file in the right panel.

Jim
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 939
Location: Red Gate Software

PostPosted: Mon Oct 04, 2010 10:03 am    Post subject: Reply with quote

Thank you for post into the forum.

SQL Backup does not support mapped drives.

When dealing with network shares, you need to specify a unc path to the share. Also the startup account given to the SQL Backup Agent service needs security permissions to the share.

Excellent news that you were able to find a solution.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
behrouz_s



Joined: 28 Dec 2013
Posts: 1

PostPosted: Sat Dec 28, 2013 7:53 am    Post subject: Re: Reply with quote

eddie davis wrote:
Thank you for post into the forum.

SQL Backup does not support mapped drives.

When dealing with network shares, you need to specify a unc path to the share. Also the startup account given to the SQL Backup Agent service needs security permissions to the share.

Excellent news that you were able to find a solution.

Many Thanks
Eddie


Hi Eddie
would you please Give me the Exact Steps to do this?

i want to Restore from a network Location which the user who is registered as startup in SQL backup Agent has Full Control on That Network Share Location and i can do every thing on that folder using Windows explorer and these Two Client and Server are Seeing Each other Very well but they are on different V-Lans but Same Domain.
I think i've checked Every Thing any any more Comments from you would be appritiated
Thanks In Advance...
Back to top
View user's profile Send private message Yahoo Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group