Red Gate forums :: View topic - Trial Version 7:Attaching to other servers to do restores...
Return to www.red-gate.com RSS Feed Available

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

Trial Version 7:Attaching to other servers to do restores...

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SQL_ME_RICH



Joined: 08 May 2012
Posts: 64

PostPosted: Fri Jun 01, 2012 10:37 pm    Post subject: Trial Version 7:Attaching to other servers to do restores... Reply with quote

Is the trail version of SQL Backup 7 able to connect to other servers when browsing the file system for backup files? I have large backup files (even with compression) on other servers that I need to use to restore those databases on yet another server.

Every time I try to attach to a server, it lets me, but when I navigate to the area I need to use a backup file from, I get errors making it seem like the file is not there.

Any thoughts would be most appreciated.
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Mon Jun 04, 2012 12:54 pm    Post subject: Reply with quote

Due to the way SQL Backup handles credentials for viewing files on other servers, there are a few known issues where remote browsing doesn't work properly. Without knowing more about your specific issue, it's hard to say exactly what it is, but it's probably one of the two following issues:

http://www.red-gate.com/supportcenter/content/knowledgebase/SQL_Backup/KB200903000369

http://www.red-gate.com/supportcenter/Content?p=SQL%20Backup&c=knowledgebase%5cSQL_Backup%5cKB200907000417.htm

Let me know if either of those articles helps at all!
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
Back to top
View user's profile Send private message
SQL_ME_RICH



Joined: 08 May 2012
Posts: 64

PostPosted: Mon Jun 04, 2012 6:29 pm    Post subject: Reply with quote

Andy - thank you for getting back to me on this. I have looked at the links you provided, but I probably need to be more specific here. It's not that in the process of doing a restore that I cannot add files from another server's share, but once I do - I get the Red X and type Unknown, and file name leading with 'Unavailable' in Red text.

Here is a snapshot for you...



I am hoping that my windows login will suffice to resolve this, because I do not have a lot of flexibility here. It's the same login for all the various boxes with the same credentials on each, but as you can see - no joy in getting to the files.

Any help would be appreciated.
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Thu Jun 07, 2012 3:18 pm    Post subject: Reply with quote

Hmm. I'd guess this was a permissions problem - the account that's running the SQL Backup Agent service on the server you're trying to run the restore on needs to have read permissions on the folder containing the backup file.

Can you confirm that the account running the SQL Backup Agent service has the appropriate permissions? You can check the account running it with the Services utility in Windows - it ought to show up as "SQL Backup Agent-<instancename>". If you right-click it and select 'Properties', you can change the account it logs on as.
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 512
Location: Costa Mesa, CA, USA

PostPosted: Fri Jul 06, 2012 12:14 am    Post subject: Reply with quote

I had the same problem!

Took a hammer to it and added the Service Account to the Local Admin Group and rebooted the server!

Works now Cool
Back to top
View user's profile Send private message
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