Backup Plan for Clustering

  • Hi,

    Need your help, have to create a backup plan for Cluster server.

    It is on SQL server 2008 with two node.

    It has 5 Instances and each instances have more than 10 database.

    Please give you valuable suggestion how to perform backup activity.

    Also if one node is failed then how the backup will continue

  • Just define normal backup jobs (to backup device or to file) on the instances as you would on any other instance - just make sure that the backup destinations are in locations accessible under the same name on all nodes (ie usually the SAN). Works for us.

  • I agree with Balance. the same setup works for us too. But incase you want better administration here is what you can do:

    > design a new database maintenance plan under the one node (or if in A/P on Primary node).

    > use SSIS data source to connect to the different instances of SQL server.

    > use backup object in SSIS to backing up databases.

    > just make sure that the destinations are on shared NAS or SAN or centralized & shared RAID desk subsystem.:-)

    HTH

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • Good point, I should have said that, we often group our backups onto maintenance plans just to make all the agent jobs clearer as to purpose - just make sure you remember to set retries & notifications if appropriate on the individual jobs as you would normally.

  • Hi vishal and Balance,

    thank's for your valuable inputs,

    Vishal can you please describe more, how to do it .

  • Hi Narender,

    you can schedule your Backup on Network drive. This will be common to all the node. I don't find there is any issue in that. Even we have databases of size more the 250 GB of size on 2-node cluster, and its working fine for me.

    Do share your inputs .

    Regards

    Dhananjay

  • If you are in SQL 2005/2008 go to Management> Maintenance plan

    1) Pull in the component called "Backup Database Task"

    2) Define a new connection to the desired server

    3) Select the databases you want to backup

    4) Select the backup type viz full, diff, log etc

    5) rest are pretty much through

    this step is optional and subjected to your requirement(s). This is just a cleanup task

    6) Pull in another component called "Maintenance Cleanup Task"

    Select the connection from the drop down you have defined for Backup Database Task

    rest are pretty much through:

    repeat these steps for each instance of SQL Server you want to backup.

    HTH

    Vishal

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply