Backup db in a cluster

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pasquale - 23 Jul 2008 12:28 GMT

In order to backup the db in a clustered instance, is it possible to use a
device mapped locally for each node of the cluster?
Has this device to belong to a resource group?
Thanks

Reply to this Message

Denny Cherry - 23 Jul 2008 17:40 GMT

Yes you can backup to a local disk or resource which is bound to a
single node of the cluster. However if it is local disk do keep in
mind that if the node fails the backup won't be available.

And no the backup device does not have to be a cluster resource.

Denny

>In order to backup the db in a clustered instance, is it possible to use a
>device mapped locally for each node of the cluster?
>Has this device to belong to a resource group?
>Thanks

Reply to this Message

Geoff N. Hiten - 23 Jul 2008 22:43 GMT

If you use a UNC name as the backup destination, you will not need to map
drives.

Signature

Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

> In order to backup the db in a clustered instance, is it possible to use a
> device mapped locally for each node of the cluster?
> Has this device to belong to a resource group?
> Thanks

Reply to this Message