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

Posted on 2010-11-23
Medium Priority
Last Modified: 2012-05-10
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?
Question by:Grizzler
  • 5
  • 2

Expert Comment

ID: 34198533
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.


Author Comment

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

Author Comment

ID: 34198669
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?
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.


Author Comment

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

Accepted Solution

ipajones earned 2000 total points
ID: 34198739
The default password for the SA account is made up of random characters durinng the install process.


This link details the required steps to change the password for the SA account:


Author Closing Comment

ID: 34198793

Author Comment

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
Dropbox has a relatively new feature called Smart Sync.  This feature allows Dropbox Professional (not plus) and Dropbox Business (if enabled) users to store information in Dropbox WITHOUT storing any files on their computer.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question