dbTalk Databases Forums  

Unable to see all partitions SQL Server Management Studio

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Unable to see all partitions SQL Server Management Studio in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
d7
 
Posts: n/a

Default Unable to see all partitions SQL Server Management Studio - 02-01-2010 , 09:49 AM






Hi,
I'm running 4 instane SQL Server 2005 in an active/passive clustered
enviroment utilizing a SAN.
I'm running out of space on one of my LUN's for one particular instance.
This instance was originally set up as follows:
LUN 1 - Database partition (3 databases) - K drive
LUN 2 - Log Partition - L drive
LUN 3 - Backup Partition - M drive

I've now added another LUN to this Resource Group within cluster
administrator. The server correctly see this new LUN which is my S drive,
however the Management Studio does not see this LUN.
I detached a database and moved it from the K drive to the S drive, but when
I tried to reattach the database I could only see the K, L and M drive I
could not see the S drive.
Any idea why this is happening?

Thanks in advance,
D7

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Unable to see all partitions SQL Server Management Studio - 02-01-2010 , 08:08 PM






You need to make the SQL service dependent upon the new disk. SQL
clustering won't allow you to store data on drives that are not on the
dependency list.

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


"d7" <d7 (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,
I'm running 4 instane SQL Server 2005 in an active/passive clustered
enviroment utilizing a SAN.
I'm running out of space on one of my LUN's for one particular instance.
This instance was originally set up as follows:
LUN 1 - Database partition (3 databases) - K drive
LUN 2 - Log Partition - L drive
LUN 3 - Backup Partition - M drive

I've now added another LUN to this Resource Group within cluster
administrator. The server correctly see this new LUN which is my S drive,
however the Management Studio does not see this LUN.
I detached a database and moved it from the K drive to the S drive, but
when
I tried to reattach the database I could only see the K, L and M drive I
could not see the S drive.
Any idea why this is happening?

Thanks in advance,
D7

Reply With Quote
  #3  
Old   
d7
 
Posts: n/a

Default Re: Unable to see all partitions SQL Server Management Studio - 02-02-2010 , 05:14 AM



Thank you Geoff, that makes sense, I shall try out of hours tonight.


"Geoff N. Hiten" wrote:

Quote:
You need to make the SQL service dependent upon the new disk. SQL
clustering won't allow you to store data on drives that are not on the
dependency list.

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


"d7" <d7 (AT) discussions (DOT) microsoft.com> wrote in message
news:2D3B8989-C84B-40BE-B275-849D55A774B4 (AT) microsoft (DOT) com...
Hi,
I'm running 4 instane SQL Server 2005 in an active/passive clustered
enviroment utilizing a SAN.
I'm running out of space on one of my LUN's for one particular instance.
This instance was originally set up as follows:
LUN 1 - Database partition (3 databases) - K drive
LUN 2 - Log Partition - L drive
LUN 3 - Backup Partition - M drive

I've now added another LUN to this Resource Group within cluster
administrator. The server correctly see this new LUN which is my S drive,
however the Management Studio does not see this LUN.
I detached a database and moved it from the K drive to the S drive, but
when
I tried to reattach the database I could only see the K, L and M drive I
could not see the S drive.
Any idea why this is happening?

Thanks in advance,
D7


.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.