What are the challenges you face when working across database platforms? Take the survey
Options

Newbie - recommended strategy for db and log backups

jimmykavjimmykav Posts: 4
edited February 3, 2010 1:33PM in SQL Backup Previous Versions
Hi, I am new to SQL Server and its backup strategies. The database I wish to backup is set to the "Full" recovery model.

I am aware that unless the Transaction Log is backed up at regular intervals the size of this log will continue to grow over time. Therefore I would like to periodically reset the Transaction Log.

If I use the “Full” backup type in SQL Backup will the Transaction Log be backed up as well, thereby allowing SQL server to reset it?

Or must I run one “Full” backup job and follow that by a “Transaction log” backup?
JimmyKav

Comments

  • Options
    Jimmy,

    If you are on SQL2005 or newer the log will not be fully backed up and therefore cleaned up if you run a Full backup. The Full will take enough of the transactions to make it fully recoverable. You must run a log backup to give you point in time recovery and to keep the log file space down.

    HTH

    Chris
    English DBA living in CANADA
Sign In or Register to comment.