June 25, 2009 at 12:52 am
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
June 25, 2009 at 2:52 am
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.
June 25, 2009 at 3:08 am
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
June 25, 2009 at 3:20 am
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.
June 26, 2009 at 1:04 am
Hi vishal and Balance,
thank's for your valuable inputs,
Vishal can you please describe more, how to do it .
June 26, 2009 at 1:14 am
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
June 26, 2009 at 1:16 am
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply