SQL database backup through BE 12.5

Hi Vicky,

Yes...

1. Buy the SQL application agent for Backup Exec and you can backup from, and restore into, the database while it is live. No need to take SQL offline;

2. If you don't buy the agent, you need to dump the SQL database to disk using SQL itself, and then backup the flat-file that was created.

Thanks!

In addition to CraigV, if you go the route of buying the SQL agent, check out the Backup Exec 12.5 Software Compatibility List (SCL) to make sure the SQL version is compatible. http://www.symantec.com/docs/TECH62301 

Hi CraigV,

   Can you tell me about How to take SQL DB Backup from BE 12.5.

For information on How to backup SQL see the Backup Exec 12.5 Admin guide starting on page 1347  http://www.symantec.com/docs/DOC2284

...I wouldn't worry about the specific section that lmosla is pointing you too...I'd suggest you read the whole Admin Guide and also take a look at the software. BE 12.5 is easy to get to know. MUCH more easy that BE 2012 if you ever move onto it.

Go through that guide, play around with the software and come to grips with it.

However...

1. Install SQL agent on media server, and then push-install RAWS agent to remote SQL server.

2. Open a current selection list, or create a new one. Select SQL.

3. Make sure AOFO is turned off when backing up SQL (or any database).

4. Create a new job/edit an existing job and run the backup.

Thanks!

what is AOFO and if it's turned ON means what is the effect?

You can look up AOFO here:

https://www-secure.symantec.com/connect/forums/glossary-make-sense-alphabet-soup

...backs up open files when turned on; either fails a job or completes with exceptions when it is turned off. The Admin Guide has ALL the basics you want to know about.

Thanks!

If AOFO is turned Off then we are unable to backup open databases correct?

    So we need to close all the data bases and then start the backup???