Post reply

truncate data in log

  • September 10, 2009 at 11:15 pm

    #225996

    hi all

    i have sql server 2005 installed for share point. it has continuous transactions.

    log file reached up to 130Gb. i want to shrink the log file. i know two steps for normal sqlserver.

    1)shrink the file

    2)detach/attach method

    can any one guide me which one is better to go for the share point sqlserver 2005?

  • September 10, 2009 at 11:23 pm

    #1052069

    Look here

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • September 10, 2009 at 11:31 pm

    #1052070

    Hi ,

    You can take log backup and shrink the files.

    How you connecting to the database?

  • September 10, 2009 at 11:45 pm

    #1052074

    i use to connect with SSMS

  • September 11, 2009 at 11:35 am

    #1052471

    Check whether if the database is in full recovery model.

    Then take log backup.

    eg: BACKUP LOG [DBA] TO DISK = N'C:\DBA_log_090909.trn'

    Take new query window and select particular database for shrinking

    Issue "checkpoint" many times in that database

    Shrink the log file.

    eg: dbcc shrinkfile (DBA__log,20)

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

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