Post reply

Alternative to "Backup Log db with Truncate_only"

  • July 2, 2012 at 1:00 am

    #271927

    "Backup Log db with Truncate_only" is deprecated in SQL Server 2008. What is the alternative to this.

    This is how I use the command:

    BACKUP LOG <database> WITH TRUNCATE_ONLY

    DBCC SHRINKFILE(database_log)

  • July 2, 2012 at 1:07 am

    #1507618

    Please read the last article I reference below in my signature block about Managing Transaction Logs. You really should not be shrinking you t-logs on a regular basis as it breaks the transaction log chain.

  • July 2, 2012 at 3:51 am

    #1507662

    Ajit-297150 (7/2/2012)

    "Backup Log db with Truncate_only" is deprecated in SQL Server 2008. What is the alternative to this.

    Simple recovery model.

    Please read through this - Managing Transaction Logs[/url]

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 2, 2012 at 3:51 am

    #1507664

    Lynn Pettis (7/2/2012)

    You really should not be shrinking you t-logs on a regular basis as it breaks the transaction log chain.

    Shrinking the log does not break the log chain. The backup with truncate_only does, not the shrink

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply