Re: [NTISP] Looking for SQL Support Group

John Lange ( )
Fri, 28 Jan 2000 10:31:25 -0600

Thanks, I will give it a try. Should I reboot after making these changes???

JOhn :}

At 10:56 AM 1/28/2000 -0500, you wrote:
>From: John Lange <>
> > Are there any good SQL eMail Groups out there? I have an M$ 6.5 sp5?
> > server and database that will not let me truncate the log file. I try and
> > it looks like it is working but never reduces the size in the EM. I am
> > continually increasing the size of the log device.
> >
> > Is there a way to DROP the Log Device and create a new one???
>I know of a really indirect/long way of doing this, but you may not need to
>do it in the first place. What settings do you have checked in...
>Double-click on your database (Emerald, I'm assuming), then click on the
>Options tab.
>We have the following checked for our Emerald database:
> Select into / Bulk copy
> No checkpoint on recovery
> Truncate log on checkpoint
>The last one is probably the most important one for not letting the logs get
>out of hand.
>For reference, our Data size is 300MB (89MB avail.); our Log size is 50MB
>(49.99MB avail). This is on a dual Pentium III 450 with 512MB RAM
>(memory=180000 (360MB RAM); tempdb in ram=50MB). We have almost 700,000
>records (99% stop records) in our Calls table and everything is still
>running as smooth as silk.
>Of course, I also have a nice SQL Server 7 box that's been sitting here for
>months waiting for me to upgrade our 6.5 SP5a, but getting around to doing
>that seems to be a bit of a problem.
>For more information about this list (including removal) go to:

----- Whatever you do, work at it with all your heart, as working for the
Lord, not for men >Colossians 3:23 (NIV)

John C. Lange, Sr. PALACE dot NET, INC. MICRO-TECH Computers, Inc.
608.742.1601 & 6980 1819 New Pinery Road Portage, WI 53901
MSCE Training for only $150.00 -
All 200+ Web Based Courses for $150.00 Per Year - "Really"

--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)

For more information about this list (including removal) go to: