Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    8

    Unanswered: Regarding Transaction file Truncation...!

    Hi All -
    SQL server truncates the Transaction log file to maintain the disk space.
    Does anyone have idea what triggers SQL server fired to truncate the log file?
    Can we trap that trigger or event so that we can control the transaction log truncation? Can we control it whne it happens?

    From R&D I found two Architecture of Transaction log:
    1) Transaction Log Logical Architecture
    2) Transaction Log Physical Architecture Can you please tell me which log file is in use when we are reading it by using DBCC log('DB_Name',4) command.
    DBCC log command read which file?
    & which file is truncated by SQL_server.
    When doing a truncation log back-up what gets backed-up if the log has been truncated?
    What method is Microsoft using in SQL Server 2005 mirroring?
    What method are companies such as SQL Server Compare using?



    Thanks,
    Baddy

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    First of all, what recovery model are we talking about here? SIMPLE, BULKLOGGED, or FULL?

  3. #3
    Join Date
    Jun 2008
    Posts
    8
    Log files truncation behavior of SQL server doesn’t depends on the recovery model selected by user. I mean to say that Transaction log file gets truncated in every case (Simple/Full/Bulk Logged), it doesn’t depend on the recovery model we selected.
    It seems that Transaction log gets truncated in every case...!

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Actually, it directly depends on the recovery model. You might want to read up on Recovery Models in Books Online. Do you happen to know what backs up this database, and how often it is doing Log backups?

Posting Permissions

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