RedGate Database disappears

gsc_ghx

We installed an additional cluster instance on a 5 node cluster. Today one of the dba's installed the server components for the new instance. Somehow the RedGate db for another instance disappeared. Has anyone seen this type of behaviour before? This was our 6th instance install on this cluster.

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

Thanks

petey

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

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

gsc_ghx

That worked...

petey

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

gsc_ghx

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

petey

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.

gsc_ghx

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