Results 1 to 2 of 2

Thread: Reducing the log file size under SQL Server 7.0

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2000
    Location
    India
    Posts
    1

    Thumbs up

    SQL SERVER - LOG FILE SIZE PROBLEM:

    I have created a database file and the log file with the size of 300 MB and 30 MB Correspondingly.

    When the volume of data grows the log file size is reached to 6 GB. My database file size is only 400 MB only.

    This is a severe problem and we need some assistance as to how to deallocate the space occupied by the log file.
    Please also advice us on whether any shrink option should be used in order to control the log file size.

    Govinda Rajan

  2. #2
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    I use BACKUP_LOG with TRUNCATE_ONLY when the log becomes big and I don't need to actually save the log

Posting Permissions

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



Click Here to Expand Forum to Full Width