Video Screencast Help

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

Created: 29 Jan 2013 • Updated: 30 Jan 2013 | 6 comments
This issue has been solved. See solution.

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

Discussion Filed Under:

Comments 6 CommentsJump to latest comment

pkh's picture

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

lubou's picture

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's picture

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's picture

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.

 

 

SOLUTION
lubou's picture

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

 

Thank you very much!

lubou's picture

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.