cancel
Showing results for 
Search instead for 
Did you mean: 

How to backup and restore SQL server?

DO2012
Level 2

 

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

2 ACCEPTED SOLUTIONS

Accepted Solutions

CraigV
Moderator
Moderator
Partner    VIP    Accredited

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!

View solution in original post

pkh
Moderator
Moderator
   VIP    Certified

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.

View solution in original post

5 REPLIES 5

CraigV
Moderator
Moderator
Partner    VIP    Accredited

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!

pkh
Moderator
Moderator
   VIP    Certified

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
Level 2

 

 

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

Thanks!

pkh
Moderator
Moderator
   VIP    Certified

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

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