Questions about backups on a production system - Full with or without Log backups
Posted on 2009-07-15
Hi, I'm working with a shop that doesn't have a DBA admin person (well, it's me for the moment but I'm a rookie) and need to get some stuff under control as fast as possible. First is transaction logs are killing us. SQL Server is SQL 2005.
I have some questions about controlling the transaction log space and trimming it back to where it ought to be.
The first step is a Backup. The production databases are in "Full" mode, unless they are mostly read-only (such as config and lookup tables). I'm really only concerned with the ones that are "Full" and hold production data.
So, I do a Full Backup.
Q1. Does the full backup ALSO include the log? Or do I immediately need to do a Log backup to get truncation?
Q2. Once I do a full backup, how do I reduce the size of the TLog again?
Those two will do for this question. I'll have another question on Employing Full Backups on a Weekly basis, Differentials on a Daily, and Log backups. But I need the answer to these two (immediately if not sooner :> )