Posted by Erland Sommarskog on 02/07/06 13:16

deebeeay@gmail.com (deebeeay@gmail.com) writes:
> I have a SQL Server 2000 database that is using the Full recovery
> model. The database is purely receiving inserts (and plenty of them)
> with maybe some view/table creation for reporting.
>
> In this state I would expect the log to grow ad infinitum but it gets
> to about 32% used and then empties.
>
> The log is not being backed up at all so am I missing something else?

Did you ever take a backup of the database since you set it to full
recovery? I believe you are effectively in simple more, until you have
a full backup. To wit, without a backup of the database, the log is very
useful on its own.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: one for the SQL experts - dare I say TRICKY SQL!
• Prev in forum: Full Recovery Model - log doesn't grow?
• Thread view: Re: Full Recovery Model - log doesn't grow?

[Reply to this message]