Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002

    Unanswered: Empty trans log in Simple model

    I have a database SQL Server 2005 Express, that's
    using the Simple recovery model.
    There's quite a big transaction log for this database,
    how do I empty it when it's the Simple model?
    Besides, the log file hasn't been updated (acc. to
    the Windows file date) since yesterday while the MDF
    file has. Is this normal?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 11
    Run DBCC SQLPERF (logspace) on the instance to see if any of the space is actually being used. If it is, run DBCC OPENTRAN in the database to see who has the open transaction.

    If the space is genuinely empty, and you do not suspect there are any giant transactions that run on this thing, you can safely shrink back the log. I find the Windows last updated dates generally doesn't mean a lot when it comes to database files.

  3. #3
    Join Date
    Jul 2002
    I couldn't manage to shrink the file. I tried setting the
    initial file size down to 2MB but it remained 15MB as
    it was (without any error message).
    Finally, I re-created the database instead, it had
    very little content anyway so it was quite easy.

Posting Permissions

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