Clean transaction log

#1

Hello,
how can I clean my transaction log? (newbie question I know).
Actually automatically clean when it is has a restricted file grow?

Thanks,

aleXsticY

#2

To automatically clean it use a backup log schedule or a
truncate log schedule. If you need to clear it right away
without backing it up use

Backup log 'dbname' with truncate_only

HTH

Ray Higdon MCSE, MCDBA, CCNA

Quote:

-----Original Message-----
Hello,
how can I clean my transaction log? (newbie
question I know).
Actually automatically clean when it is has a restricted
file grow?

Thanks,

aleXsticY

.

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

Clean transaction log

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Clean transaction log - 07-04-2003 , 12:38 PM

Clean transaction log - 07-04-2003 , 01:54 PM