[dba-SQLServer]Win2K Large Hard Disk Support

Thanks John, I am actually looking at 2 different drives for an upgrade 
I currently have a 60gig, a 120 (partitioned into 3 slices) and a small 
5gig, and am planning to get rid of the 5gig and upgrade to something 
around 160 - 200gig.  Of course I'll let you know how I did. (patches or 
no patches ;o)


John Colby wrote:
>>If you have not updated your bios, it may be necessary to do that first.
> 
> 
> That is always the first thing I check when installing a new motherboard.
> There is no newer bios available for this board, and the board supports
> ATA133 natively.
> 
> 
>>Very interesting, though the article seems to imply that the primary
> 
> partition should not exceed the 137gigs, which is sound advice.
> 
> The way I read it, if you don't have SP3 installed then Windows would
> "think" the disk was the max size it understood and set it up as that.  I
> thought it was very poorly written and left a lot of holes as to what it was
> really doing.  I really posted it as a warning to those getting ready to
> purchase a new drive.  The "sweet spot" is about to swing past 120g over to
> 160g, at which time more and more people are going to run into problems.
> 
> John W. Colby
> www.colbyconsulting.com
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
> Francisco H Tapia
> Sent: Tuesday, September 23, 2003 1:43 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer]Win2K Large Hard Disk Support
> 
> 
> John Colby wrote:
> 
>>For anyone interested (and willing to risk installing MS Service Packs ;-)
>>
>>Here is the knowledgebase article that discuses Windows 2000 lack of
> 
> support
> 
>>for large hard disks prior to SP3.  Watch line wrap.
>>
>>
> 
> http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
> 
>>80/support/kb/articles/q305/0/98.asp&NoWebContent=1
>>
> 
> 
> Very interesting, tho the article seems to imply that the primary
> partition should not exceed the 137gigs, which is sound advice.  This
> could be why you have been experiencing this problem.  It also did
> mention that you should have a compatible bios.  If you have not updated
> your bios, it may be necessary to do that first.

-Francisco