Post reply

Truncating the transaction log

  • June 5, 2004 at 2:49 pm

    #87510

    Hi,

    I am trying to shrink the transaction log that has grown to about 28 GB. I wish to keep the transactions of the last 2 months intact and remove the earlier transaction logs. I do know that when I perform a full backup and use DBCC Shrinkfile, I would be able to shrink the file. But, I would like to know if there are any arguments to the DBCC Shrinkfile that would allow me to keep the transactions of last 60 days. Any help is greatly appreciated.

    Gopi

  • June 6, 2004 at 11:57 am

    #509154

    Hi,

    If you are taking full backup daily then why you need the transaction of the last 2 month. You can keep the transaction log backup of the last 2 month.Why don't you do the follwoing

    Full backup of DB on daily basis.

    Transaction Log backup every during the day at spacific time interval.

    Truncate the log just before the Full backup

    Full backup of DB

    Shrink Log file

    No need to mention that you have to copy all the backup file on the backup server from the database server for recovery.

    As far as my knowledge on sql I can say we can only spacify the size not the time on the DBCC shrinkfile option.

    I hope I understand you query properly.

    Good Luck

    Deep

Viewing 2 posts - 1 through 1 (of 1 total)

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