Also bear in mind that database size also includes indexes and enough of
them can turn a fairly small set of data into a large database file. There
is a procedure to break down the amount of space being used by all tables,
indexes etc. May be worth looking at.
Justin
Justin Greene
Co-CEO
ClicVU, Inc.
216 West 18th St., Floor 12 - NYC 10011
P: 212-242-0258 x 101 - F: 212-242-9355
http://www.clicvu.com
---------------------------------------------------------------------
Sign up for your free Spamex account:
http://www.spamex.com
Protect your real email address forever
---------------------------------------------------------------------
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 10:26 AM
To: CF-Talk
Subject: RE: Backing up large database
On 7/25/01, Dave Watts penned:
> > Man, what do you have in that database? LOL I've got databases on my
>> SQL Server that aren't HUGE, but they do have some rather large
>> tables (30 fields or so) with several thousand records in them and
>> they're only 11-12 MB. Do you have the database options set to
>> Auto-Shrink?
>
>In enterprise database terms, several thousand records is a very small
>amount.
I understand that, but 1.2 GB seems like a pretty large database.
Yes, I know they can get to be terabtyes. :) I just thought maybe he
wasn't shrinking it. Just something for him to look at.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
