cancel
Showing results for 
Search instead for 
Did you mean: 

SQL database backup through BE 12.5

vigneshwaran
Level 6

Hi Team,

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

1 ACCEPTED SOLUTION

Accepted Solutions

CraigV
Moderator
Moderator
Partner    VIP    Accredited
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!!!

View solution in original post

9 REPLIES 9

CraigV
Moderator
Moderator
Partner    VIP    Accredited

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!

lmosla
Level 6

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 

vigneshwaran
Level 6

Hi CraigV,

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

 

lmosla
Level 6

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

CraigV
Moderator
Moderator
Partner    VIP    Accredited

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

vigneshwaran
Level 6

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

CraigV
Moderator
Moderator
Partner    VIP    Accredited

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!

vigneshwaran
Level 6

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

CraigV
Moderator
Moderator
Partner    VIP    Accredited
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!!!