transaction log for the simple recovery model

15 Dec 2005 5:41 AM

Wendy Elizabeth

The database that I just started to work with has a simple recovery model.
The actual production database is 5 gigs while the transaction log table is
98 gigs. I can not figure out how the transaction log became so large. There
has never been a backup taken of the transaction log. How can the transaction
log keep growing if the transaction log is never used by the recovery model?

Thanks!

15 Dec 2005 6:42 AM

Danijel Novak

Hi,

Transaction Log is used for statements like insert, update and delete
althought recovery mode is simple. It just minimizes logging for certain
operations (BOL - Minimally Logged Operations)
So you should look after log not to become to big.

--
Danijel Novak

Show quote

"Wendy Elizabeth" <WendyElizab***@discussions.microsoft.com> wrote in
message news:78B9463F-7988-45EE-B65F-B3CBB84074E8@microsoft.com...
> The database that I just started to work with has a simple recovery model.
> The actual production database is 5 gigs while the transaction log table
> is
> 98 gigs. I can not figure out how the transaction log became so large.
> There
> has never been a backup taken of the transaction log. How can the
> transaction
> log keep growing if the transaction log is never used by the recovery
> model?
>
> Thanks!
>