Re: [Veritas-bu] Backing up cluster after failover
2009-06-12 12:18:25
I think you mentioned database cluster in an earlier post?
here's how I have my sql cluster set up:
physical node hostnames:
sql1 (192.168.0.1)
sql2 (192.168.0.2)
cluster node hostname:
sqlclus (192.168.0.3)
I have two policies for my sql cluster (well, *I* have more than two, but for
the purpose of this example, it's two):
WindowsOS-ClusterNodes
contains ALL_LOCAL_DRIVES for sql1 & sql2
SQLCluster
contains FULL SQL backup for sqlclus (runs that feature-rich BCH file)
On SQL1 and SQL2, I have the excludes set for every drive but C for my
"WindowsOS-ClusterNodes" policy, so the ALL_LOCAL_DRIVES directive won't grab
the sql data volumes (all drives > C).
Of course, if someone puts a file on one of the drives other than C, it won't
get backed up, but you do avoid the partial backup errors resulting from trying
to file-level-backup locked sql db files.
If you're running it all on C, you could do the same with a path-based exclude
instead of a drive-based one.
I have this same kind of procedure running with Enterprise Vault and with
Windows File Server clusters (get system data only with one clusternode policy
that points to the physical nodes, get clustered data with another that points
to the clustered hostname).
Hopefully that made sense..
~ Robin
-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of
smwoodcrafts
Sent: Friday, June 12, 2009 8:46 AM
To: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: [Veritas-bu] Backing up cluster after failover
It might be easier, because I'm new to this and probably not explaining it
correctly, to just ask what are the correct steps when configuring for backup
of the floating drives in a cluster. There has to be something I missed. This
would be an all Windows environment and I would need steps on configuring the
client software, from start to finish. If someone could please explain this to
me, I would appreciate it.
smwoodcrafts
+----------------------------------------------------------------------
|This was sent by dseymour AT ap DOT org via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
|
|