10-17-2013 12:54 PM
Hi Team,
Is it possible to take Microsoft SQL database backup from BE 12.5???
Solved! Go to Solution.
10-19-2013 12:51 PM
10-17-2013 01:35 PM
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!
10-17-2013 01:42 PM
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
10-17-2013 01:53 PM
Hi CraigV,
Can you tell me about How to take SQL DB Backup from BE 12.5.
10-17-2013 02:05 PM
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
10-17-2013 11:08 PM
...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!
10-18-2013 02:04 PM
what is AOFO and if it's turned ON means what is the effect?
10-19-2013 02:11 AM
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!
10-19-2013 11:19 AM
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???
10-19-2013 12:51 PM