[dba-SQLServer] Big db update

Michael Maddison mmaddison at optusnet.com.au
Fri Aug 27 23:05:38 CDT 2004


EM -> Database -> Properties -> the last tab IIRC.
You probably need to backup the db/log file then shrink it.

cheers

Michael M


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

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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.718 / Virus Database: 474 - Release Date: 9/07/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.718 / Virus Database: 474 - Release Date: 9/07/2004




More information about the dba-SQLServer mailing list