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.