Solved

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

Posted on 2010-11-23
7
883 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
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Life is full of imperfections – we all know it. Sometimes bad things happen to people for no particular reason. As they say: “it happens”. All we can do is to find a way to make some unavoidable situations… avoidable. Every kind of hardware has i…
Replication has always been one of those technologies that people run scared from. The main reason is usually cost. When you think of replication, your mind drifts to solutions that replicate from one disk frame to another using block level technolo…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
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…

864 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now