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

SQL database backup through BE 12.5

Created: 17 Oct 2013 • Updated: 18 Nov 2013 | 9 comments
This issue has been solved. See solution.

Hi Team,

         Is it possible to take Microsoft SQL database backup from BE 12.5???

Operating Systems:

Comments 9 CommentsJump to latest comment

CraigV's picture

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!

Alternative ways to access Backup Exec Technical Support:

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

vigneshwaran's picture

Hi CraigV,

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

- Vicky
CraigV's picture

...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!

Alternative ways to access Backup Exec Technical Support:

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

vigneshwaran's picture

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

- Vicky
CraigV's picture

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!

Alternative ways to access Backup Exec Technical Support:

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

vigneshwaran's picture

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???

- Vicky
CraigV's picture

If you have Windows Server 2003 and higher then BE uses VSS...AOFO is not needed for databases as it causes issues during the backups. I have had a situation where i could not do a redirected SQL restore.
Go underthe Articles secrion and filter for mine...i wrote an article about splitting your backups from each other. Use AOFO when backing up files and folders, and run another job without AOFO when backing up databases.
You have the SQL agent...you should already knownthis means you do not have to take SQL offline!!!

Alternative ways to access Backup Exec Technical Support:

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

SOLUTION
lmosla's picture

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 

lmosla's picture

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