Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

How to backup the Backup Exec Database

Created: 13 Oct 2011 • Updated: 12 Feb 2013 | 18 comments
This issue has been solved. See solution.

Hi

I'm running Windows 2008 R2 server with Backup Exec 2010 R3 and HP MSL 4048 Tape libary.

I want to backup the Backup Exec Databse every day to one of my LTO tapes.

I need to be sure that if my server fails i won't loose the database containg the backup jobs, restore jobs, etc.

How can i do it?

Thanks

 

Dori

Comments 18 CommentsJump to latest comment

AmolB's picture

Everyday Backup Exec runs a database maintenace and creates a backup of the database.

Its saved as BEDB.bak and its located at X:\Program Files\Symantec\Backup Exec\Data\

You can add the above file in the daily backup selection list.

I would also suggest you to take backup of the Catalogs folder once in a week which will 

save your time at the time of Disaster Recovery.

dori_bashan's picture

 

"I would also suggest you to take backup of the Catalogs folder once in a week which will 

save your time at the time of Disaster Recovery."

How can i do it?

VJware's picture

Just adding-on to the previous comment -

Database Maintenance runs at 4.00am everyday by default & the schedule can be configured from Tools - Options - Settings - Database Maintenance

You may also consider using the BEUtility to dump the BEDB database - http://www.symantec.com/docs/TECH83082

Lastly, before copying the DATA & the CATALOG folders to an alternate,safe location, do stop the BE services including the SQL instance.

 

EDIT** Backing up the Catalogs here is a reference to manually copying the folder to an alternate location

dori_bashan's picture

If i will copy the DATA and CATALOGS folders each day to a safe location, do i have to stop the services before doing that? even if i'm doing it while BE is not doing anything?

I want to write a script that will copy those folders each day to a safe location.

 

Thanks!

AmolB's picture

Before copying above folders you need to stop the SQL server BKUPEXEC service.

If you perform above task once in a week that is more  then enough.

Colin Weaver's picture

If you set the maintenace schedule to 10-15 minutes before you run your backup job for the BEDB.BAK and the catalogs folders etc then you do not need to stop the services as the content of the MDF andf LDF files will be inside the BEDB and can be recoverd with BEUTILITY or with SQL Studio Managerment tools at a later date.

 

BTW do make sure the date of BEDB.BAK is changing as if it is not then somethign will be stopping a valid backup.

dori_bashan's picture

Ok..

Another question...

If the server crushed, and i got no backup of the Backup Exec database, is it possible to restore the database from the LTO tapes inside the MSL 4048??

As far as i know, the DB is also kept on the LTO tape itself, am i right?

Thanks

Dori

AmolB's picture

As far as i know, the DB is also kept on the LTO tape itself, am i right?

If you select BEDB.bak for backups and if its there on the LTO tape, you will be able to 

restore the database.

pkh's picture

The DB is only stored on your tapes if you backup the Data directory.  If you do backup the Data directory, you can do a restore and re-direct it to another directory and then replace the new Data directory.

Colin Weaver's picture

Note to do the first restore 9to get back teh BackuP Exec Database) you would need to Catalog and Inventory the tape with the BEDB on it. As such it is good practioce to keep a manual record of whyuich tapes contain the BEDB from specific dates so that you know which tapes to catalog and inventory.

dori_bashan's picture

But how will i be able to restore the DATA directoty from the LTO tape if i got no databse that knows where the DATA directory is stored on?

is Catalog and Invetory is the actions i will need to perform?

So if i know that the DATA directory is stored on tape #001, i will need to put that tape in the drive, and run Catalog and Invetory on it, then i will be able to restore the DATA directory, and re-direct this directory into the c:/program files/backup exex/data?

So basicly, if i dont have any database at all, and i dont have the DATA dierctory backup up, i can always put each tape in the drive and by doing Catalog and Inventory, i will be able to restore each tape database?

 

 

Dori

pkh's picture

When restore your server, you need to install the OS, then BE.  You then catalog the tape with the Data directory on it and then restore the Data drectory somewhere.  You then replace the Data directory of the new BE installation with your old Data directory.

dori_bashan's picture

Understood.

But, if i dont have any BU of the DATA folder, is it possible to restore the database by Catalog and Invetory each tape?

AmolB's picture

Upon completion of the catalog job for any tape you can procced with restoration 

of data which resides on the tape

dori_bashan's picture

Thank you!

One last thing..

How can i control the Invetory job scuduale?

I made a script that will stop all BE services, run a copy of the DATA and CATAOGS folders to an external disk,and start the services again.

I dont want BE to start an invertory each time i'm starting the service.

Where can i configure it?

Thanks

CraigV's picture

...by default BE doesn't run an automated inventory. This is something you need to set up yourself. If you restart the services it won't initiate any inventory or catalog job.

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

SOLUTION