RedGate Database disappears

• 

  And how to I re-install \ restore this database?

  Stop and restart the SQL Backup Agent service/cluster resource.

  petey May 10, 2011 05:51

  - 0 +
• 
  That worked...

  gsc_ghx May 10, 2011 09:42

  - 0 +
• 
  The only time SQL Backup deletes the local data store is when you ask it to, when you uninstall SQL Backup.

  petey May 10, 2011 12:19

  - 0 +
• 
  I am having this issue again.
  
  I have stopped and restarted the service many times.
  
  Then get the error again.
  
  Error is: Failed to initialize local data store: File already exists. Try using a different database name......
  
  Any help is appreciated.
  
  Thank you
  Geri

  gsc_ghx June 18, 2011 15:24

  - 0 +
• 
  We'll need to turn on tracing in the SQL Backup Agent service itself to troubleshoot this. Ensure that no SQL Backup processes are running. Since you are running a cluster, you should disable the SQL Backup Agent service first in the Cluster Administrator. Then stop the SQL Backup Agent service.
  
  Open the registry, and look for the SQL Backup Agent service definition. For the default instance, this would be
  
  HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\SQLBackupAgent
  
  For a named instance, this would be
  
  HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\SQLBackupAgent_<instance name>
  
  - Look for the ImagePath value, and edit its data. Add -sqbdebug to the end of the startup parameter e.g.
  
  C:\Program Files\Red Gate\SQL Backup\(LOCAL)\SQBCoreService.exe ... -sqbdebug
  
  Start the service, and enable it in the Cluster Administrator (if you're running a clustered instance). A log file named SQBCoreService_log.txt should be generated in the folder where SQBCoreService.exe is installed. Please send me that log file.
  
  Thanks.

  petey June 19, 2011 21:41

  - 0 +
• 
  Peter - I found that the user the backup agent is running under did not have sufficient rights to the redgate folder. I have changed the backup agent user back to what it was prior to the update on Friday night. If I have this issue again and it is not user related - I will then turn debugging on.
  
  Thank you so much for responding...
  
  Geri

  gsc_ghx June 20, 2011 10:37

  - 0 +

Add comment

Please sign in to leave a comment.