Post reply

Deleting LOG FILES automatically

  • January 23, 2004 at 2:49 am

    #107714

    Please suggest me a way where in the log files in SQL SERVER are deleted automaticallty at the end of the day at certain time.

  • January 23, 2004 at 6:52 am

    #491334

    Do you really want to delete them or just shrink them back to as close to original size as possible?

  • January 23, 2004 at 6:55 am

    #491336

    If all you want is to shrink them try:

     

    BACKUP LOG dbname WITH TRUNCATE_ONLY

    DBCC SHRINKFILE(dbname_Log, truncateonly)

  • January 28, 2004 at 7:22 am

    #491940

    Be sure to do a full backup after the truncate_only. I'm wondering, what exactly are the ramifications of truncate_only? Is it only clearing unneeded transactions?


    Terry

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

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