After running the CHECKPOINT command, the following sqlperf data was returned:

Log Size (MB) Log Space Used (%)

------------- -------------------

...

Just in case there is any confusion as to the process in place, here is (hopefully) a better description.

- Process Starts

--- backup PROD db

--- backup STAGING db

...

Unfortunately, yes.

The whole DB is generated from scratch each day, so, apparantly the powers that be decided Simple logging was the way to go.

As I said in the beginning, I...

Apologies on posting this in the SQL Server 2005 forum. I missed the header when I started the thread. I have opened a post in the SQL 2K...