That stopped my log from growing without a re-start.
I still need to know if there is a way to DROP the log and re-create
it... Any Clue's??? My log device is 1600MB with 89MB Available.
I would also like to shrink my data device, I had a corrupt calls table,
now that it is repaired I have a 1500MB data device with 300MB of data, yes
1200MB free
JOhn :}
At 11:48 AM 1/28/2000 -0500, you wrote:
>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
----- 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