[dba-SQLServer] Big db update

I looked at them Arthur.  I had already purchased 2 200g hard disks to put
in my server to hold this, having no idea how big it would be but figuring
that if push came to shove I could use a raid0 to get 400g.  The 200g drives
are the sweet spot on the price/performance curve right now.  If I can get
the raid1 to compress I can get about 800mb for somewhere in the
neighborhood of $250, otherwise it will be 400 which it appears will NOT be
enough.  

8-(

Speaking of compression, does anyone know what the key is to getting a drive
to compress?  I looked it up in help and it says just that it has to be a
NTFS drive.  These are but the "allow compression" check box is not
available.  I got one of my external disks to compress, the other I couldn't
see that check box.  No idea why or what the pattern is.

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 Arthur
Fuller
Sent: Wednesday, August 25, 2004 8:50 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Big db update


Since it's getting so large, I wish you had looked into the LaCie drives I
mentioned earlier. In case you missed that post, visit www.lacie.com. 

Arthur

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W.
Colby
Sent: Wednesday, August 25, 2004 7:19 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Big db update


I looked at Shrink which will reduce the current size by 30% according to
EM.  It appears that the extra space is there for future expansion and
seeing as I have a slew more files to import there is no point in doing so
YET.

I will keep you in mind for those hard questions about largish DBs!

John W. Colby
www.ColbyConsulting.com 


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com