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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy