11-21-2012 01:08 PM
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
Solved! Go to Solution.
11-21-2012 01:22 PM
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!
11-21-2012 05:48 PM
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.
11-21-2012 01:22 PM
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!
11-21-2012 05:48 PM
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.
11-22-2012 06:42 AM
Isn’t there one single way to recover the complete server that comes with all the apps settings dbs etc etc ?
Thanks!
11-22-2012 05:18 PM
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.
11-22-2012 10:22 PM
You'd have to put the whole server into a selection list to accomplish this.