Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Unanswered: transaction log file

    Hie,
    I have a transaction log files which grow to 24 Go but today there is only 100 mo uses, my backup is less than 100 mo but my files is 24 go, how can i reduce the size of my log file ?

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    You need to backup the transaction log file - and then shrink it. It may not shrink immediately, but it will eventually after a couple of trans log backups over a couple of days - it will.

    Alternatively alter your recovery model to simple, this will reduce the log file immediately, but it will also mean that you have no point-in-time recovery capability any more.
    Regards
    Dbabren

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •