October 13, 2010 at 3:10 am
Hi List,
I just setup SQL 2008 Failover cluster on windows 2008 Failover cluster. Following this I am going to prepare backup strategy for the databases. I have checked around for papers and documentations regarding backup strategy in Failover cluster environment. However, I could not find any helpful materials.
Therefore, I was wondering if anyone can give me a hint on backup strategy that I can implement in a failover cluster environment. I would appreciate if there are papers which discuss about the strategies.
Also I appreciate if anyone can share experience on this topic.
Thanks in advance for your hint.
Kind regards
Niyala
October 13, 2010 at 3:15 am
Same as backup strategies for a non-clustered setup. Clustering does not change how, when and why you would back databases up.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2010 at 3:20 am
Thanks a lot.
So this means that if I create a backup job schedule on one of the nodes, this would be sufficient? Would the job failover in case of failover?
Regards
Niyala
October 13, 2010 at 3:53 am
SQL server and SQL agent are both cluster-aware services. Jobs are stored in a SQL Server database, in msdb.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2010 at 4:42 am
Thank you very much indeed. I'll start in our lab.
Kind regards
Niyala
October 13, 2010 at 5:24 pm
I use Backup Exec 2010 with the SQL Server agent and I point it at the cluster virtual server (not the actual node).
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply