[dba-SQLServer] Big db update

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




More information about the dba-SQLServer mailing list