• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 892
  • Last Modified:

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?
0
Grizzler
Asked:
Grizzler
  • 5
  • 2
1 Solution
 
ipajonesCommented:
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.


0
 
GrizzlerAuthor Commented:
That is my question... Is there a way to login..  ie what is default sa pwd...
0
 
GrizzlerAuthor Commented:
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?
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
GrizzlerAuthor Commented:
So I want this list:
Tell me the backup history for file: \\x\y\z.tzt
0
 
ipajonesCommented:
The default password for the SA account is made up of random characters durinng the install process.

http://www.symantec.com/business/support/index?page=content&id=TECH23877

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

0
 
GrizzlerAuthor Commented:
Thanks!
0
 
GrizzlerAuthor Commented:
Actually, the windows login used for admin during setup gets you in.....
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now