July 17, 2002 at 1:08 am
Hi,
I've got some troubles to reduce Log allocation space.
With SQL2000 I used the folowing script with good results:
-- BACKUP DU LOG
BACKUP LOG eluxembourg
WITH TRUNCATE_ONLY
-- TRUNCATE DE LA DB
DBCC SHRINKDATABASE (eluxembourg, TRUNCATEONLY)
-- VIDE LE LOG
DBCC SHRINKFILE (eluxembourg_LOG, EMPTYFILE)
But it does not reducing the log on SQL Server7
why ?
July 17, 2002 at 5:18 am
SQL7 requires a little more work. Shouldnt, but it does. Basically you have to generate filler transactions in the log to get it to move to the next virtual log segment. We've got a a link to a script around here somewhere that will do it for you...Antares, got it handy?
Andy
July 17, 2002 at 5:47 am
Here is Steve's posted script:
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 17, 2002 at 7:34 am
Wow, it does the job!
Thanks.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply