JOhn :}
At 10:56 AM 1/28/2000 -0500, you wrote:
>From: John Lange <radadmin@palacenet.net>
> > 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.
>
>Josh
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
----- 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.
microjl@palacenet.net MICRO-TECH Computers, Inc.
608.742.1601 & 6980 1819 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
MSCE Training for only $150.00 - http://dpec.palacenet.net/
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:
http://www.iea-software.com/support/maillists/liststart