Post reply

truncating transaction log files

  • November 29, 2004 at 4:50 am

    #109767

    Hi guys

    I just want to find out if running dbcc shrinkfile and backup log is transparent to users. So I don't need to wait for out of office hours to run this processes.

    cheers...

  • November 29, 2004 at 5:54 am

    #531697

    Backup log should be however, I think that DBCC SHRINKFILE will be noticed as this may prevent new records from being written to the log while it is running.

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • November 29, 2004 at 6:17 am

    #531702

    cheers for your reply i actually sorted the logs by just running dbcc shrinkfile and didn't need to backup the logs...

  • November 29, 2004 at 7:07 am

    #531713

    To Truncate the Logs :

    Backup Log [DB_Name] with truncate_only

    Thanks and Regards,

    sadha

  • November 30, 2004 at 3:58 pm

    #531985

    hi

    And then shrink the file if the log file size is very large using dbcc shrinkfile o in sql 2000 throught EM

     

    .

    JR

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

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