cancel
Showing results for 
Search instead for 
Did you mean: 

Can Symantec System Recovery back up and restore MS SQL database?

liuyang
Level 6
Partner Accredited

Hi, our customer has one Windows server (Windows Server 2008 R2 SP1 Std) which has MS SQL server 2014 installed.

My question is: 

If I use Symantec System Recovery 2013 R2 to back up the whole server, will the MS SQL database be included in the backups? If yes, when I restore the full server, will the database automatically be restored? If no, is there a way in SSR to back up MS SQL database separately?

Thanks in advance.

2 ACCEPTED SOLUTIONS

Accepted Solutions

TRaj
Level 6
Employee Accredited

The SCL does not list MS SQL 2014

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

SO the version of SQL is not supported with SSR 2013 R2

But yes if you backup all the drives it will backup the database as well and while you restore it will also restore the database automatically.

View solution in original post

criley
Moderator
Moderator
Employee Accredited

You are looking at the wrong SCL. Here is the SCL for 2013 R2:

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

SQL 2014 is supported!

View solution in original post

2 REPLIES 2

TRaj
Level 6
Employee Accredited

The SCL does not list MS SQL 2014

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

SO the version of SQL is not supported with SSR 2013 R2

But yes if you backup all the drives it will backup the database as well and while you restore it will also restore the database automatically.

criley
Moderator
Moderator
Employee Accredited

You are looking at the wrong SCL. Here is the SCL for 2013 R2:

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

SQL 2014 is supported!