Re: [NTISP] Looking for SQL Support Group

Josh Hillman ( (no email) )
Fri, 28 Jan 2000 11:48:48 -0500

From: John Lange <radadmin@palacenet.net>
> Thanks, I will give it a try. Should I reboot after making these
changes???

No, there's no reason/need to reboot the server.
I can't remember if you need to stop/restart SQL or not though. I don't
think you have to, but I can't remember off-hand.

Josh

> 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

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart