I've built a 2008 R2 Cluster running sql 2008 as a clustered application. We do full backups with arcserve. I'm trying to come up with a process to get the cluster back online for disaster recovery. I can get the Windows cluster back online
but when it comes to sql I get stuck. Would I basically get the cluster back online than use the command - setup /action=rebuilddatabase /instancename=MSSQLServer /sqlsysadminaccounts=domain\username? Than start the database in single user mode,
install the arcserve sql agent and restore all the db's?
When I try this I get the error element does not exist error. Right, now I'm starting from scratch to see if I get the same result. I just want to make sure I'm on the right track and not spinning my wheels trying something that won't work
in a clustered application.
View Complete Post