How to do backup in Cluster

Hi,

I have a cluster set up and working fine. I am in a stage where I need to do the backups. I have added 4 disks as dependecies to the sql service for the instance. The backups should not be on these disks. When I do a simple backup I can see only these 4 disks so my question is how do I do the backup to fileshare or other disks that are not partof the cluster. I have 3 virtual servers so what wil be the best thing to do for backup

Thanks

Adminanup,

What is preventing you from backing up to a fileshare?

-Matt

|||

Is there a reason for not sending your backups to disks which are part of your cluster group?

Certainly you wouldn't send backups to the same disk as the database is stored on, but another disk in the same group should work just fine.

|||

Thanks

It was a firewall issue and could not backup to a fileshare.

Like you have mentioned what is the best practices in backing up DB in cluster

1. fileshare

2. add a disk resouce(which I assume will fail evertime SQL will failover) to the SQL group in cluster and add as dependency

Thanks

|||I would choose #2 for performance reasons.|||

Thanks Kevin,

I would think backing to fileshare would be efficient as in case of failover it has to failover the backup disk as a resouce so can you please give me some insight as why this is recommended as compnared to #1

|||

Hello,

The failover of a disk resource is usually very quick (and given it is used for backup which can be reissued, thus not impacting service, is not time critical), so the duration of failover should not be an issue. I would think #2 was chosen for performance as it does not involve moving data across the network as per option 1.

Cheers,
Rob