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

How to backup and restore SQL server?

Created: 21 Nov 2012 | 5 comments

Hi all,

How can I backup with Symantec Backup Exec 2012 the whole Microsoft SQL server (OS, applications, database, everything) for total disaster recovery and how I can restore it. Do I need extra feature or agent for full recovery?

Thank you in advance

Comments 5 CommentsJump to latest comment

CraigV's picture

Hi,

You need the Agent for Applications and Databases to be installed on your media server which allows you to backup SQL.

From there, push-install the RAWS agent (remote agent) from your media server to the remote server.

You can then follow the best practices below:

http://www.symantec.com/docs/HOWTO74429

Thanks!

Alternative ways to access Backup Exec Technical Support:

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

pkh's picture

On top of installing the Agent for Databases and Applications licence and backing your SQL databases, you would need to set up a seperate job to backup the files of the SQL Server machine.  A seperate job is needed because you need to turn on AOF for this job, whereas AOF should be off for the SQL database backup job.

For recovery, you should first use SDR to recover your SQL Server machine.  When it is working, you then restore your SQL databases from your backups.  It is a two-stage recovery process.

DO2012's picture

 Isn’t there one single way to recover the complete server that comes with all the apps settings dbs etc etc ?

Thanks!

pkh's picture

Nope.  Not for physical machine backups.  AFE will exclude any .mdf and .ldf files from the backup, so it is always a 2-step restore process.

For VM backups, you can restore the entire vmdk/vhd and get back everything.

CraigV's picture

You'd have to put the whole server into a selection list to accomplish this.

Alternative ways to access Backup Exec Technical Support:

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