Home Forums Database Design Disaster Recovery Does the full backup clear/truncate the t-log? RE: Does the full backup clear/truncate the t-log?

  • November 14, 2011 at 9:40 am

    #1407333

    JakeSA (11/14/2011)

    None of the database options (configurable in SSMS or sp_configure or sp_dboption) are applicable to the log file. They are applicable to the data (MDF and NDF) files only.

    Database options meaning???????

    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