I've built an active/active SQL 2005 cluster using LUNs for SQL, Data, and Logs.

Unfortunately, I tried to use local storage (both machines have a local B:) for backups - hey, shared storage is expensive and this is only a temporary location that awaits another routine that moves the SQL backups to tape.

Anyway, SQL doesn't seem to like the local B: in the cluster.

Is there any way to use the local drives? UNC paths?

I'm afraid that it is obvious that I'm new at this - please educate me.


EDIT: I'm confused. It seems that the local B: is working after all - the DBA says it was failing before due to an integrity check. So are local drives available or not?

I tried to access the UNC path first, but that definitely failed. Typing in B:... seems to be working, you just can't browse to it.

So I'm not sure how to resolve that experience with the experience of Massimo that I marked below.


A clustered installation of SQL Server will only be able to directly access clustered disks; there's no workaround for that.

You can backup to a network location, of course.

  • In order do backup to a network location, the user account SQL Server uses to run needs to have access to the network share; so, if your SQL Server instance is running as "DOMAIN\sql.server", you need to give that user write access to the location you're saving your backups to. – Massimo Aug 31 '09 at 21:15
  • Thanks for the clarification on the network share. What about the seemingly working local drive - do you expect that this will fail in some fashion under certain conditions? Thanks – Jason Kleban Aug 31 '09 at 22:23
  • It could work (as long as you have a B: drive on both nodes), but I'm quite sure it's not supported. – Massimo Sep 1 '09 at 6:35
  • I'm quite sure it would be supported, if the same drive letter exists on each node. Not all resources accessed by a clustered instance need to be clustered. – Aaron Alton Sep 2 '09 at 1:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.