Backing up windows 2008 2-node cluster and SQL Server 2008
I've been doing some research on how to back up Windows clusters. We have a windows 2008 2-node failover cluster that uses shared storage and quorum disks (NetApp NFS disks). We also run SQL server on this cluster, with the databases and msdtc also stored on shared disks.
I have found documents regarding backing up windows clusters (both native windows backup and netbackup) and sql backups and restores (netbackup) however, i haven't found anything about how to back up an environment such as ours, and restore as is, either to another cluster or to another separate single server.
I have set up the following:
back up the system drive and system state using the native windows backup facility (to enable BMR and cluster restoration) on each node
back up the system drive using netbackup on each node
back up the shared storage drives using netbackup using the windows cluster name (as this sees the disks on the active node)
back up SQL using netbackup using the sql cluster name (as this sees the database on the active node)
i have tried to cover all angles regarding backups, however I am at a loss as to how to restore this all and whether this backup plan is actually entirely correct.
is anyone running the same environment as this? and how have you arranged your backups? is your backup plan more simple than this, and is your restore plan straightforward?
any help would be appreciated.