Colby, John
JColby at dispec.com
Thu Aug 26 09:13:08 CDT 2004
Francisco, Last night I tried to modify the log file size. It was already up to around 10 gb and refused to allow me to set the numbers down. Something about "can only expand the file". Where do I find these "bulk logged" or "SIMPLE" settings? JWC -----Original Message----- From: Francisco Tapia [mailto:fhtapia at gmail.com] Sent: Wednesday, August 25, 2004 12:07 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Big db update On Wed, 25 Aug 2004 07:19:07 -0400, John W. Colby <jwcolby at colbyconsulting.com> wrote: > 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! You are becoming quite the VLDB expert :), one question I had for you, on your log file settings do you have your db set to either BULK Logged or SIMPLE, this will reduce the amount of records stored in the transaction log while you are doing this "Massive" rollup. -- -Francisco _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com