log. To do this, you have to issue a bunch of dummy queries. This page
explains a bit more:
http://www.tek-tips.com/gfaqs.cfm/pid/183/fid/345
Here's a script:
http://www.bstconsultants.com/tsug/Dec99/REDUCING_THE_SIZE_OF_THE_LOG_FILE.h
tm
You may have to run the script many times depending on how big the log file
is and how far the active portion is from end of the log file.
Ben Rogers
http://www.c4.net
v.508.240.0051
f.508.240.0057
________________________________________
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 13, 2004 10:00 AM
To: CF-Talk
Subject: OT- SQL backup question
I back up my transaction log with the following script. How come after the
script runs (successfully), the .LDF file is still large and not smaller? I
thought when you backed up the file it is completely truncated thus freeing
up space?
BACKUP LOG AVPhoneLookup
TO DISK= 'g:\avbkp\avp_trans.bak'
WITH INIT
________________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
