0

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.

Thanks!

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.

1 Answer 1

1

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.

4
  • 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, 2009 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 Aug 31, 2009 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, 2009 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. Sep 2, 2009 at 1:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .