Home Forums SQL Server 2005 SQL Server 2005 General Discussion SQL backups and truncation RE: SQL backups and truncation

  • December 17, 2007 at 4:06 pm

    #760863

    We're using Full for the recovery model in SQL Server 2005. So, does that mean that the log file won't be truncated when a backup occurs?

    In our test database server we have all databases' recovery models set to Simple. Would those get truncated after a backup?

    Kindest Regards, Rod Connect with me on LinkedIn.