SDR and cluster node

[jinxnbu]

Can Backup Exec SDR feature successfully recover a system which has SQL installed and is part of cluster. (Always On).

[pkh]

SDR can be used to recover any Windows server, but it does not recover the data of any application/database.  For SQL Server databases, regardless of whether they are in a cluster or not, you have to run a job to restore the data after the server is recovered.  This 2-step recovery procedure cannot be avoided whether you are doing a manual recovery or a SDR recovery.

You might want to take note of this document

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

[jinxnbu]

Thanks pkh.. I am aware of the limited support of Always on with BE. 

I am currently taking a native sql backup to a local drive and then backing up the dump using BE. 

If i recover the sql server using SDR, SQL doesnt start up properly and hence i cant recover the data from the dump. Is there a way to work around it ?

[pkh · Accepted solution]

Unfortunately, no.

The SQL probably did not start up because you did not backup the Master and other system databases with the BE SQL agent.