Newbie - recommended strategy for db and log backups
jimmykav
Posts: 4
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?
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
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