JFulford Posted December 19, 2007 Report Share Posted December 19, 2007 We are using Retrospect 7.5.387 with Hot fix 7.5.13.100 and are having some issues backing up with our SQL databases. Some times retrospect will backup all the databases and other times it will only back up a few. We don’t receive any errors in the log as it only sees the databases that get backed up. It looks like it has a problem enumerating the databases. Is this a known problem and do you have any ideas on a solution? Quote Link to comment Share on other sites More sharing options...
Mayoff Posted December 19, 2007 Report Share Posted December 19, 2007 From the user's guide: Critical steps Part 1 You must create a Retrospect Backup User account (RBU) that is a member of: 1) Domain Users 2) Domain Administrators 3) Backup Operators 4) Local Admins if Retrospect is running local to the SQL server 5) Do NOT include any other groups Part 2 1) Go to Configure>Preferences>Security in Retrospect and configure Retrospect to Run as a specific user. 2) Enter the RBU info into the Security settings. 3) Go to Configure>Volumes. Right Click on the sql Server and select "Login As" 4) Configure Retrospect to login to the sql server using the Retrospect User account. Running Retrospect as the "domain administrator" is not good enough and you must use the steps in Part 1 above. Quote Link to comment Share on other sites More sharing options...
mgthe3 Posted September 9, 2008 Report Share Posted September 9, 2008 What support forgets to tell you (have been on phone for HOURS with them) is that the SQL Agent service logon has to be the same as the Retrospect service logon..... took us a month to figure this out. Quote Link to comment Share on other sites More sharing options...
alturas Posted February 17, 2009 Report Share Posted February 17, 2009 Hello... I don't understand ... I do all what you write ... but still having problem, authentication problem, when I try to add SQL Server as Source. It's correctly licensed Retrospect 7.6 is running on a windows server 2008 enterprise 64 bit, Sql2008 is running on another server, same operating system. I create RBUser member of the groups you write, setting retrospect to run with this credential ... no way. Then I try to add RBUser to Enterprise Admins... no way. Then I modify the SQL Agent service to run as RBUser ... no way, always authentication error. If I login to the sql server with the RBUser credential i'm able to connect to sql and to run management studio etc. ... but from retrospect always authentication problem .... any idea ? Quote Link to comment Share on other sites More sharing options...
alturas Posted April 20, 2009 Report Share Posted April 20, 2009 Problem solved. http://kb.dantz.com/display/2/articleDirect/index.asp?aid=9703&r=0.5313227 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.