| Tracy McKibben 2006-10-24, 6:38 pm |
| tractng@gmail.com wrote:
> Tracy,
>
> Would backing up using the GUI be enough? Does the GUI "Full Backup"
> take care of the log problem that I had stated earlier or do I have to
> do the transaction log backup separate?
>
> Still new to the backup command so I don't want to use it yet till I
> test it.
>
A full backup does not truncate the transaction log. I'm guessing,
since you're asking these questions, that you don't fully understand how
the transaction log is used. You have a couple of options:
1. Spend some time in Books Online, learning about how that mechanism
works, and how it protects you from data loss. Backing up the
transaction log at regular intervals gives you the ability to restore a
database to virtually any point in time. You first have to understand
how the log is used, and what to do with those backups if/when you need
them.
or
2. Put your databases into Simple mode, eliminating the need to
truncate the transaction log. You don't have to perform transaction log
backups, but you also have a higher risk of data loss.
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|