asked on

Backup Exec: Is there a way to connect to the SQL database created by backup exec?

I have Backup Exec 10 running tapes, and 12 running Backup To Disc. I would like to build custom queries on the database using SQL tools. Is there a way to connect directly to the database?

ipajones

You could use "osql" to connect to the SQL instance or in enterprise manager register a new sql server it should show up as servername\bkupexec but I wouldn't recommend it. In addition it's unlikely that you'll know the password for the SA account and resetting it may cause problems with BackupExec running.

You should use "BEUtility.exe" to maintain or check the database.

Grizzler

ASKER

That is my question... Is there a way to login.. ie what is default sa pwd...

Grizzler

ASKER

Maybe this will help... My backups are full and incremental on disc. User calls and says " I hosed file \\x\y\z.txt., can you restore?" I proceed to check backwards through incrementals until I find when the file (out of over a million) was last backed up. Is there a built in way to search backup history for a specific file?

Grizzler

ASKER

So I want this list:
Tell me the backup history for file: \\x\y\z.tzt

ASKER CERTIFIED SOLUTION

ipajones

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Grizzler

ASKER

Thanks!

Grizzler

ASKER

Actually, the windows login used for admin during setup gets you in.....