Results 1 to 2 of 2

Thread: Transactional Log Problem

  1. #1
    Join Date
    Aug 2003
    Location
    London
    Posts
    110

    Transactional Log Problem

    Hi,

    I have got a database (SQLSRV2000 Enterprise), and it has got one transactional log file.
    if I set the Transactioal file size to 1500MB and auto growth on (no limit) over night the trans. log expands up to 2300MB
    I have tried to set the Initial value the trans. file to 2500MB but next day the log file will be 1500 again!! in the database options the auto shink is on.
    My understanding was that the auto shrink option, shrinks transactional log and also data(.mdf) file.

    Is there any way to disable the shrinking option only on the transaction log not the data files(.mdf)

    Thanks

    S

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    The right way to do this is to
    a. uncheck remove autoshrink option
    b. Set your database to FULL recovery mode
    c. set min size + autogrowth option on data and log files.
    d. Take frequent transaction log backup.

Posting Permissions

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