Advertisement

06.11.2008 at 04:18PM PDT, ID: 23477790 | Points: 250
[x]
Attachment Details

Clustered SQL 2005 Server Cannot See Log Drive on SAN

Asked by jmoney68 in SQL Server 2005, MS SQL Server

Tags: , , ,

I just built a SQL 2005 Cluster (2 node, active/passive).  The configuration of the cluster went smoothly, and during that process I configured a Cluster Group for SQL with two drives: Drive U: (for databases) and drive V: (for logs).  Both drives are located on an iSCSI SAN.  Everything failed over from one node to the other consistently during extensive testing, including the drives.  In addition, each physcial node saw the drives and could access them each time they were the active node.  I then installed SQL 2005 software with the cluster option and that went without a hitch.

Once everything was up, the next thing that I wanted to do was to change the default locations of the databases and logs.  The databases were already defaulted to drive U:, which was fine.  However, when I went to change the default location of the logs to drive V: through the SQL Server Management Studio, the only drive it could see was drive U: and not the other drive.  As a result, all of the databases and logs are still on the same drive.

Does anyone have any idea why the SQL Server cannot see the drive, even though the node and the cluster see it just fine?

ThanksStart Free Trial
[+][-]06.12.2008 at 08:42AM PDT, ID: 21770703

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 09:57AM PDT, ID: 21771441

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 09:58AM PDT, ID: 21771451

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 10:20AM PDT, ID: 21771638

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 10:34AM PDT, ID: 21771770

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 10:43AM PDT, ID: 21771850

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 02:19PM PDT, ID: 21773817

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.17.2008 at 05:44AM PDT, ID: 21802317

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.18.2008 at 10:46AM PDT, ID: 21815208

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.18.2008 at 10:49AM PDT, ID: 21815243

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628