Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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.