Solved

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

Posted on 2010-11-23
7
888 Views
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?
0
Comment
Question by:Grizzler
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 6

Expert Comment

by:ipajones
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.


0
 

Author Comment

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

Author Comment

by:Grizzler
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?
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

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

Accepted Solution

by:
ipajones earned 500 total points
ID: 34198739
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
 

Author Closing Comment

by:Grizzler
ID: 34198793
Thanks!
0
 

Author Comment

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

Featured Post

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

691 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