Re: log and SP

#1

You could back it up before the SP, then truncate it afterwards, unless
space is an issue I don't know that I would shrink it as it will grow every
night.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"hutch" <hutch (AT) nospam (DOT) com> wrote

Quote:

I have a wicked SP, by wicked I mean several temp tables,
lots of inserts, updates and deletes. I don't have time
to rewrite this SP right now so I need to fix a problem it
is causing. The problem is when it's run it blows the log
from 25 mb to 270 mb.
What would the best way to keep it from logging all the
changes?
I'm thinking about changing the db recovery from full to
simple then back again.
Or
Should I backup the log and shrink it after it runs?

The SP is only run once at night.

Anyone have any other ideas?

Thanks

-Hutch

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: log and SP

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: log and SP - 08-12-2003 , 12:17 PM