Post reply

Shrinking Log File

  • December 9, 2002 at 11:47 am

    #65082

    I am running a process that currently is making my trans log run out of control. My data file size is 2500 mb but my log is 24000 mbs. Once the process is finished, what would be the best way (and safest) to reduce the actual size of that log according to NT. Dettach and reattach using sp and do not reattach the log?

  • December 9, 2002 at 12:01 pm

    #443823

    Hi,

    I usually fall into this kind of situation.

    I take the backup of the trascation log with no_log command and then shrink the file.

    Once it's done i take the backup of my database.

    Hope this helps.

  • December 9, 2002 at 12:20 pm

    #443825

    Mkumari suggestion sounds good, and normally works for me.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • December 9, 2002 at 12:23 pm

    #443828

    SQL 7 or SQL 2K? If SQL 7, download the forcibly shrink tran log script Steve Jones posted to the site. You'll need it.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply