Can Backup Exec SDR feature successfully recover a system which has SQL installed and is part of cluster. (Always On).
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.
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
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 ?
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.
