I was going through the threads and noticed that the database for Backup Exec is MSDE based. I was wondering is there a way to have a Local SQL server query the database instance for Backup Exec. To find out for example Tape Allocated Date, Overwrite date etc.
I was working on something similar awhile ago and got pulled off it but yes you can access it and querry it. In enterprise manager register a new sql server it should show up as servername\bkupexec. You can then brows the tables looking for the information you want and use querry analyzer to querry it with whatever you want. I was getting tapename job completion status bytes backed up and putting it all on a serchable coldfusion page so I didnt have to manually write down all backup information to logs just print out a page and I was done. If your interested I'll try and dig up my notes on what I did it was like 6 months ago and I'll be gone for a few days.
Hi, It seems that you have installed backup exec in to its own MSDE instance on the system having SQL locally installed.Hope our understanding is correct.
In enterprise manager you can register a new sql server it should show up as servername\bkupexec. You can then brows the tables looking for the information you want and use query analyzer to query it with whatever you want.
This takes care of one part, what is the default password for the sa logon on that database? It may have already been assigned, in which case, is there some way to change the password through the backup exec program.