Find mssql instance name of BE database (for monitoring purposes)

[lubou]

Hello,

where does Backup Exec store the instance name of its database (registry, file)? 

I want to be able to discover it (by script) for monitoring purposes.

Thanks

[pkh]

The instance name is BACKUPEXEC. What and how are you going to use to monitor it?

[lubou]

I have been assuming that the instance name is "BKUPEXEC", however, I came across a system where the name was different.

I guess the fact that the instance name you mentioned differs from the ones I have observed on different systems means that assuming name X is not foolproof.

Backup exec must store the name somewhere and I would like to know where.

I am monitoring several things, among them are service dependencies of the backup exec services.

[pkh]

Sorry.  My mistake.  It is BKUPEXEC.  Haven't have my first cup of coffee.  :)

I would guess it is in the registry since it is a service.

[Colin_Weaver · Accepted solution]

I believe that if you check in either:

HKLM\SOFTWARE\Symantec\Backup Exec for Windows\BEDatabase

that using a custom instance name is used that the value

"Server Database Instance Name" will exist

 OR

HKLM\SOFTWARE\Symantec\Backup Exec for Windows\Adamm

the following value will exist

"Database Instance Name"

Note: I can't confirm this on my test server as I have used default of BKUPEXEC (which is used if these keys do not exist.)

Other places to check - the ADAMM.log file (in ..\Backup Exec\Logs) after the services start - as this file appends, always read from bottom upwards to locate the most up to date info. You will have to scroll up a few lines to see the instance name it won't be right at the end.

[lubou]

This sounds what I was looking for. I will verify and report back soon'ish.

Thank you very much!

[lubou]

Ok, I can confirm 

HKLM\SOFTWARE\Symantec\Backup Exec for Windows\Adamm\Database Server Name

Edit: 

I can also confirm HKEY_LOCAL_MACHINE\SOFTWARE\Symantec\Backup Exec For Windows\BEDatabase.

It contains server and instance name.

Thank you for your help.