Groups | Blog | Home
all groups > sql server clustering > january 2006 >

sql server clustering : ClusterBack and Restore



Vai2000
1/27/2006 10:53:16 AM
What's the best way to backup cluster and restore it incase of outage?

TIA
Env: MSCS 2000
OS: Win2000 Adv Srv
SQL2k

Rodney R. Fournier [MVP]
1/27/2006 4:07:39 PM
System State backups of the nodes, $ backup of the shared disks, SQL file
backup to a shared disk. Test, test, test. To know if you have everything
for a restore, perform one on your test cluster.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training

[quoted text, click to view]

Vai2000
1/27/2006 8:22:50 PM
Shouldn't we use the Cluster SDK API for backup?
BackupClusterDatabase
RestoreClusterDatabase

TIA

"Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in
message news:uA0rX44IGHA.3452@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view]

Rodney R. Fournier [MVP]
1/30/2006 12:43:27 PM
Cluster Aware backup software, no clue on API's - I am not a programmer!

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training

[quoted text, click to view]

AddThis Social Bookmark Button