 |
|
 |
|
Next: Cluster problem sql server 2000 active/passive is..
|
| Author |
Message |
External

Since: Jul 23, 2007 Posts: 17
|
(Msg. 1) Posted: Thu Feb 14, 2008 11:23 am
Post subject: SQL 05 ENT Cluster: not enough disk space for data files Archived from groups: microsoft>public>sqlserver>clustering (more info?)
|
|
|
so i've built up my w2k3 ent 64bit cluster with no problems... its all happy
and working well... created the DTC resource and went to install SQL.. it
goes well until it asks what group to put it in and what disk to use for the
data files.
I select the group and the path it presents is correct. I click Next and it
tells me it doesnt have enough space.
the drive is a 500GB partition which i would assume is more than large
enough.
Im able to access the storage just fine, have written data there, it fails
over just fine... looks fine to me..
why on earth is it telling me 500GB isnt enough?!
PS: if anyone from MS is looking at this, your link to diagnose the error
sent me off to a message about using a strong password for SA.... i assume
thats wrong
Thanks
Justin
Error msg details:
TITLE: Microsoft SQL Server Setup
------------------------------
These is not enough disk space on the destination disk for the current SQL
Server data files. To proceed, free up disk space to make room for data
files, or install the data files to a different drive.
For help, click:
http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Ser...&ProdVe
------------------------------
BUTTONS:
OK
------------------------------ >> Stay informed about: SQL 05 ENT Cluster: not enough disk space for data files |
|
| Back to top |
|
 |  |
External

Since: Mar 08, 2005 Posts: 6
|
(Msg. 2) Posted: Thu Feb 14, 2008 11:23 am
Post subject: RE: SQL 05 ENT Cluster: not enough disk space for data files [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
Silly questions, I'm sure you've checked. Is the quorum disk available with
ample free space? How about the volume where you are storing the executables
(e.g., c:\program files\yada yada)?
"Justin Rich" wrote:
> so i've built up my w2k3 ent 64bit cluster with no problems... its all happy
> and working well... created the DTC resource and went to install SQL.. it
> goes well until it asks what group to put it in and what disk to use for the
> data files.
>
> I select the group and the path it presents is correct. I click Next and it
> tells me it doesnt have enough space.
>
> the drive is a 500GB partition which i would assume is more than large
> enough.
>
> Im able to access the storage just fine, have written data there, it fails
> over just fine... looks fine to me..
>
> why on earth is it telling me 500GB isnt enough?!
>
>
> PS: if anyone from MS is looking at this, your link to diagnose the error
> sent me off to a message about using a strong password for SA.... i assume
> thats wrong
>
>
> Thanks
> Justin
>
>
>
>
> Error msg details:
> TITLE: Microsoft SQL Server Setup
> ------------------------------
>
> These is not enough disk space on the destination disk for the current SQL
> Server data files. To proceed, free up disk space to make room for data
> files, or install the data files to a different drive.
>
> For help, click:
> http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Ser...&ProdVe
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
> >> Stay informed about: SQL 05 ENT Cluster: not enough disk space for data files |
|
| Back to top |
|
 |  |
External

Since: Mar 08, 2005 Posts: 6
|
(Msg. 3) Posted: Thu Feb 14, 2008 11:23 am
Post subject: RE: SQL 05 ENT Cluster: not enough disk space for data files [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
That would be good - I have run into remote installs not showing all the
options for install, but not the error you've seen. Either copying the ISOs
to the local disk (I use Daemon tools to run) or the disk contents have
helped my problems with the install.
-b
"Justin Rich" wrote:
> so i've built up my w2k3 ent 64bit cluster with no problems... its all happy
> and working well... created the DTC resource and went to install SQL.. it
> goes well until it asks what group to put it in and what disk to use for the
> data files.
>
> I select the group and the path it presents is correct. I click Next and it
> tells me it doesnt have enough space.
>
> the drive is a 500GB partition which i would assume is more than large
> enough.
>
> Im able to access the storage just fine, have written data there, it fails
> over just fine... looks fine to me..
>
> why on earth is it telling me 500GB isnt enough?!
>
>
> PS: if anyone from MS is looking at this, your link to diagnose the error
> sent me off to a message about using a strong password for SA.... i assume
> thats wrong
>
>
> Thanks
> Justin
>
>
>
>
> Error msg details:
> TITLE: Microsoft SQL Server Setup
> ------------------------------
>
> These is not enough disk space on the destination disk for the current SQL
> Server data files. To proceed, free up disk space to make room for data
> files, or install the data files to a different drive.
>
> For help, click:
> http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Ser...&ProdVe
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
> >> Stay informed about: SQL 05 ENT Cluster: not enough disk space for data files |
|
| Back to top |
|
 |  |
External

Since: Jul 23, 2007 Posts: 17
|
(Msg. 4) Posted: Thu Feb 14, 2008 12:50 pm
Post subject: Re: SQL 05 ENT Cluster: not enough disk space for data files [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
both C and D have about 28GB and those are the local drives. the Quorum
drive is 500MB and is only using about 10MB (hopefully sql doesnt try to
touch this drive) and the shared drive has 500GB..
I am installing this from a network share.... im going to move the files
local and give that a try... it could make a difference..
"Bill P" wrote in message
> Silly questions, I'm sure you've checked. Is the quorum disk available
> with
> ample free space? How about the volume where you are storing the
> executables
> (e.g., c:\program files\yada yada)?
>
> "Justin Rich" wrote:
>
>> so i've built up my w2k3 ent 64bit cluster with no problems... its all
>> happy
>> and working well... created the DTC resource and went to install SQL.. it
>> goes well until it asks what group to put it in and what disk to use for
>> the
>> data files.
>>
>> I select the group and the path it presents is correct. I click Next and
>> it
>> tells me it doesnt have enough space.
>>
>> the drive is a 500GB partition which i would assume is more than large
>> enough.
>>
>> Im able to access the storage just fine, have written data there, it
>> fails
>> over just fine... looks fine to me..
>>
>> why on earth is it telling me 500GB isnt enough?!
>>
>>
>> PS: if anyone from MS is looking at this, your link to diagnose the error
>> sent me off to a message about using a strong password for SA.... i
>> assume
>> thats wrong
>>
>>
>> Thanks
>> Justin
>>
>>
>>
>>
>> Error msg details:
>> TITLE: Microsoft SQL Server Setup
>> ------------------------------
>>
>> These is not enough disk space on the destination disk for the current
>> SQL
>> Server data files. To proceed, free up disk space to make room for data
>> files, or install the data files to a different drive.
>>
>> For help, click:
>> http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Ser...&ProdVe
>>
>> ------------------------------
>> BUTTONS:
>>
>> OK
>> ------------------------------
>>
>>
>> >> Stay informed about: SQL 05 ENT Cluster: not enough disk space for data files |
|
| Back to top |
|
 |  |
External

Since: Jul 23, 2007 Posts: 17
|
(Msg. 5) Posted: Thu Feb 14, 2008 1:14 pm
Post subject: Re: SQL 05 ENT Cluster: not enough disk space for data files [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
No luck with that... i tried running it from local storage and it still
wasnt happy
I guess i'll try burning the CDs...
"Justin Rich" wrote in message
> both C and D have about 28GB and those are the local drives. the Quorum
> drive is 500MB and is only using about 10MB (hopefully sql doesnt try to
> touch this drive) and the shared drive has 500GB..
>
>
> I am installing this from a network share.... im going to move the files
> local and give that a try... it could make a difference..
>
>
> "Bill P" wrote in message
>
>> Silly questions, I'm sure you've checked. Is the quorum disk available
>> with
>> ample free space? How about the volume where you are storing the
>> executables
>> (e.g., c:\program files\yada yada)?
>>
>> "Justin Rich" wrote:
>>
>>> so i've built up my w2k3 ent 64bit cluster with no problems... its all
>>> happy
>>> and working well... created the DTC resource and went to install SQL..
>>> it
>>> goes well until it asks what group to put it in and what disk to use for
>>> the
>>> data files.
>>>
>>> I select the group and the path it presents is correct. I click Next and
>>> it
>>> tells me it doesnt have enough space.
>>>
>>> the drive is a 500GB partition which i would assume is more than large
>>> enough.
>>>
>>> Im able to access the storage just fine, have written data there, it
>>> fails
>>> over just fine... looks fine to me..
>>>
>>> why on earth is it telling me 500GB isnt enough?!
>>>
>>>
>>> PS: if anyone from MS is looking at this, your link to diagnose the
>>> error
>>> sent me off to a message about using a strong password for SA.... i
>>> assume
>>> thats wrong
>>>
>>>
>>> Thanks
>>> Justin
>>>
>>>
>>>
>>>
>>> Error msg details:
>>> TITLE: Microsoft SQL Server Setup
>>> ------------------------------
>>>
>>> These is not enough disk space on the destination disk for the current
>>> SQL
>>> Server data files. To proceed, free up disk space to make room for data
>>> files, or install the data files to a different drive.
>>>
>>> For help, click:
>>> http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Ser...&ProdVe
>>>
>>> ------------------------------
>>> BUTTONS:
>>>
>>> OK
>>> ------------------------------
>>>
>>>
>>>
>
> >> Stay informed about: SQL 05 ENT Cluster: not enough disk space for data files |
|
| Back to top |
|
 |  |
External

Since: Dec 05, 2007 Posts: 2
|
(Msg. 6) Posted: Fri Feb 15, 2008 10:13 am
Post subject: Re: SQL 05 ENT Cluster: not enough disk space for data files [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
another stupid question perhaps, but when you are installing, does the
installer actually list the clustered drive that you are to use for the sql
files? If not then the lack of space will be related to the fact that it is
not actually seeing a drive with space.
"Justin Rich" wrote in message
> No luck with that... i tried running it from local storage and it still
> wasnt happy
>
> I guess i'll try burning the CDs...
>
>
> "Justin Rich" wrote in message
>
>> both C and D have about 28GB and those are the local drives. the Quorum
>> drive is 500MB and is only using about 10MB (hopefully sql doesnt try to
>> touch this drive) and the shared drive has 500GB..
>>
>>
>> I am installing this from a network share.... im going to move the files
>> local and give that a try... it could make a difference..
>>
>>
>> "Bill P" wrote in message
>>
>>> Silly questions, I'm sure you've checked. Is the quorum disk available
>>> with
>>> ample free space? How about the volume where you are storing the
>>> executables
>>> (e.g., c:\program files\yada yada)?
>>>
>>> "Justin Rich" wrote:
>>>
>>>> so i've built up my w2k3 ent 64bit cluster with no problems... its all
>>>> happy
>>>> and working well... created the DTC resource and went to install SQL..
>>>> it
>>>> goes well until it asks what group to put it in and what disk to use
>>>> for the
>>>> data files.
>>>>
>>>> I select the group and the path it presents is correct. I click Next
>>>> and it
>>>> tells me it doesnt have enough space.
>>>>
>>>> the drive is a 500GB partition which i would assume is more than large
>>>> enough.
>>>>
>>>> Im able to access the storage just fine, have written data there, it
>>>> fails
>>>> over just fine... looks fine to me..
>>>>
>>>> why on earth is it telling me 500GB isnt enough?!
>>>>
>>>>
>>>> PS: if anyone from MS is looking at this, your link to diagnose the
>>>> error
>>>> sent me off to a message about using a strong password for SA.... i
>>>> assume
>>>> thats wrong
>>>>
>>>>
>>>> Thanks
>>>> Justin
>>>>
>>>>
>>>>
>>>>
>>>> Error msg details:
>>>> TITLE: Microsoft SQL Server Setup
>>>> ------------------------------
>>>>
>>>> These is not enough disk space on the destination disk for the current
>>>> SQL
>>>> Server data files. To proceed, free up disk space to make room for data
>>>> files, or install the data files to a different drive.
>>>>
>>>> For help, click:
>>>> http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Ser...&ProdVe
>>>>
>>>> ------------------------------
>>>> BUTTONS:
>>>>
>>>> OK
>>>> ------------------------------
>>>>
>>>>
>>>>
>>
>>
>
> >> Stay informed about: SQL 05 ENT Cluster: not enough disk space for data files |
|
| Back to top |
|
 |  |
External

Since: Jul 23, 2007 Posts: 17
|
(Msg. 7) Posted: Fri Feb 15, 2008 10:13 am
Post subject: Re: SQL 05 ENT Cluster: not enough disk space for data files [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
yeah, when you pick a cluster group it looks for disks in that group and
automatically assigns the following path; X:\Microsoft SQL Server
I have two groups and i can watch it auto upate the drive letter in the path
between Q and R... Q, as you can guess is for my Quorum and R is for my
data. I obviously try to install with the group containing the R drive,
which is 500GB and completely empty...
I did notice that for some reason my drives are accessible (not just
visable) to both cluster nodes (and its an active passive, i think? or at
least that was the goal)
Im not entirely sure how to make a cluster a/a vs a/p
"Mark B" wrote in message
> another stupid question perhaps, but when you are installing, does the
> installer actually list the clustered drive that you are to use for the
> sql files? If not then the lack of space will be related to the fact that
> it is not actually seeing a drive with space.
>
> "Justin Rich" wrote in message
>
>> No luck with that... i tried running it from local storage and it still
>> wasnt happy
>>
>> I guess i'll try burning the CDs...
>>
>>
>> "Justin Rich" wrote in message
>>
>>> both C and D have about 28GB and those are the local drives. the Quorum
>>> drive is 500MB and is only using about 10MB (hopefully sql doesnt try to
>>> touch this drive) and the shared drive has 500GB..
>>>
>>>
>>> I am installing this from a network share.... im going to move the files
>>> local and give that a try... it could make a difference..
>>>
>>>
>>> "Bill P" wrote in message
>>>
>>>> Silly questions, I'm sure you've checked. Is the quorum disk available
>>>> with
>>>> ample free space? How about the volume where you are storing the
>>>> executables
>>>> (e.g., c:\program files\yada yada)?
>>>>
>>>> "Justin Rich" wrote:
>>>>
>>>>> so i've built up my w2k3 ent 64bit cluster with no problems... its all
>>>>> happy
>>>>> and working well... created the DTC resource and went to install SQL..
>>>>> it
>>>>> goes well until it asks what group to put it in and what disk to use
>>>>> for the
>>>>> data files.
>>>>>
>>>>> I select the group and the path it presents is correct. I click Next
>>>>> and it
>>>>> tells me it doesnt have enough space.
>>>>>
>>>>> the drive is a 500GB partition which i would assume is more than large
>>>>> enough.
>>>>>
>>>>> Im able to access the storage just fine, have written data there, it
>>>>> fails
>>>>> over just fine... looks fine to me..
>>>>>
>>>>> why on earth is it telling me 500GB isnt enough?!
>>>>>
>>>>>
>>>>> PS: if anyone from MS is looking at this, your link to diagnose the
>>>>> error
>>>>> sent me off to a message about using a strong password for SA.... i
>>>>> assume
>>>>> thats wrong
>>>>>
>>>>>
>>>>> Thanks
>>>>> Justin
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Error msg details:
>>>>> TITLE: Microsoft SQL Server Setup
>>>>> ------------------------------
>>>>>
>>>>> These is not enough disk space on the destination disk for the current
>>>>> SQL
>>>>> Server data files. To proceed, free up disk space to make room for
>>>>> data
>>>>> files, or install the data files to a different drive.
>>>>>
>>>>> For help, click:
>>>>> http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Ser...&ProdVe
>>>>>
>>>>> ------------------------------
>>>>> BUTTONS:
>>>>>
>>>>> OK
>>>>> ------------------------------
>>>>>
>>>>>
>>>>>
>>>
>>>
>>
>>
>
> >> Stay informed about: SQL 05 ENT Cluster: not enough disk space for data files |
|
| Back to top |
|
 |  |
External

Since: Jul 23, 2007 Posts: 17
|
(Msg. 8) Posted: Fri Feb 15, 2008 10:13 am
Post subject: Re: SQL 05 ENT Cluster: not enough disk space for data files [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
FIXED!
I think my problem was that both systems had access to the drive.. I had
shut node 2 off while building the cluster so im not sure what i did
different this time but now i can only use the drives from the active
node...
Thanks guys
"Justin Rich" wrote in message
> yeah, when you pick a cluster group it looks for disks in that group and
> automatically assigns the following path; X:\Microsoft SQL Server
>
> I have two groups and i can watch it auto upate the drive letter in the
> path between Q and R... Q, as you can guess is for my Quorum and R is for
> my data. I obviously try to install with the group containing the R drive,
> which is 500GB and completely empty...
>
> I did notice that for some reason my drives are accessible (not just
> visable) to both cluster nodes (and its an active passive, i think? or at
> least that was the goal)
>
> Im not entirely sure how to make a cluster a/a vs a/p
>
> "Mark B" wrote in message
>
>> another stupid question perhaps, but when you are installing, does the
>> installer actually list the clustered drive that you are to use for the
>> sql files? If not then the lack of space will be related to the fact that
>> it is not actually seeing a drive with space.
>>
>> "Justin Rich" wrote in message
>>
>>> No luck with that... i tried running it from local storage and it still
>>> wasnt happy
>>>
>>> I guess i'll try burning the CDs...
>>>
>>>
>>> "Justin Rich" wrote in message
>>>
>>>> both C and D have about 28GB and those are the local drives. the Quorum
>>>> drive is 500MB and is only using about 10MB (hopefully sql doesnt try
>>>> to touch this drive) and the shared drive has 500GB..
>>>>
>>>>
>>>> I am installing this from a network share.... im going to move the
>>>> files local and give that a try... it could make a difference..
>>>>
>>>>
>>>> "Bill P" wrote in message
>>>>
>>>>> Silly questions, I'm sure you've checked. Is the quorum disk available
>>>>> with
>>>>> ample free space? How about the volume where you are storing the
>>>>> executables
>>>>> (e.g., c:\program files\yada yada)?
>>>>>
>>>>> "Justin Rich" wrote:
>>>>>
>>>>>> so i've built up my w2k3 ent 64bit cluster with no problems... its
>>>>>> all happy
>>>>>> and working well... created the DTC resource and went to install
>>>>>> SQL.. it
>>>>>> goes well until it asks what group to put it in and what disk to use
>>>>>> for the
>>>>>> data files.
>>>>>>
>>>>>> I select the group and the path it presents is correct. I click Next
>>>>>> and it
>>>>>> tells me it doesnt have enough space.
>>>>>>
>>>>>> the drive is a 500GB partition which i would assume is more than
>>>>>> large
>>>>>> enough.
>>>>>>
>>>>>> Im able to access the storage just fine, have written data there, it
>>>>>> fails
>>>>>> over just fine... looks fine to me..
>>>>>>
>>>>>> why on earth is it telling me 500GB isnt enough?!
>>>>>>
>>>>>>
>>>>>> PS: if anyone from MS is looking at this, your link to diagnose the
>>>>>> error
>>>>>> sent me off to a message about using a strong password for SA.... i
>>>>>> assume
>>>>>> thats wrong
>>>>>>
>>>>>>
>>>>>> Thanks
>>>>>> Justin
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> Error msg details:
>>>>>> TITLE: Microsoft SQL Server Setup
>>>>>> ------------------------------
>>>>>>
>>>>>> These is not enough disk space on the destination disk for the
>>>>>> current SQL
>>>>>> Server data files. To proceed, free up disk space to make room for
>>>>>> data
>>>>>> files, or install the data files to a different drive.
>>>>>>
>>>>>> For help, click:
>>>>>> http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Ser...&ProdVe
>>>>>>
>>>>>> ------------------------------
>>>>>> BUTTONS:
>>>>>>
>>>>>> OK
>>>>>> ------------------------------
>>>>>>
>>>>>>
>>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
> >> Stay informed about: SQL 05 ENT Cluster: not enough disk space for data files |
|
| Back to top |
|
 |  |
| Related Topics: | How much disk for ms-dtc cluster resource ? - hello, I'm about to install a 2-nodes Windows 2003 Cluster, with 2 SQL Server 2005 instances: I've read in MS documentation that clustering MS-DTC is recommended, but I can't find how much disk space shoud I reserve for it group: can you tell me what...
a question regarding disk in cluster - Hi Guys, I have a active/passive cluster and there are 3 drives setup that is in SAN(X, Y, and Z). In cluster administrator, I can see all of them. But I cannot see the all of them and I can see only X drive in sql server. e.g. When I restore backup..
Add SAN Disk Resource to Active/Active SQL cluster - Looking to see if I am missing any steps below to adding a SAN disk resource to an Active/Active SQL cluster: -Create Volumes -Present LUNs to both Nodes -Failover Cluster Groups to Node2 -On Node1 Disable ClusDisk Disable Cluster Services Reboot Node...
Physical Disk counter does not show up in cluster - The Physical Disk and Logical Counters do not show up in the cluster or node performance counters. I have verified that DiskPerf is supposed to install the counters at bootup (diskperf -y), but they do not show up in the Performance Monitor. For the...
64-bit Windows / 64-bit SQL - External Disk Array (cluster) - oops, post should have gone to this forum ..... Hi, I read in the SQL 2005 Exam guides for clustering that (p.283 - 70-443), that if building a cluster on 64-bit Windows then must use Fibre drives? I'm trying to verying this with help of Google/MSDN,... |
|
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
|
|
|
|
 |
|
|