SEO

#1 (**permalink**) 02-29-2008, 06:19 PM

Hi all,

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?

Cheers
Dee

#2 (**permalink**) 02-29-2008, 06:19 PM

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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#3 (**permalink**) 02-29-2008, 06:19 PM

Ah that's probably it. I've only just been given visibility of the
database and I don't think a backup has ever been done.

Many thanks for your help!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Full Recovery Model - log doesn't grow?