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