Posted by Matik on 02/28/06 08:54

Erland,

I've changed to full model (not bulk).
I'm backuping transaction log each 15 minutes (maybe thats why the used
space is so small).
Transaction log backups are aprox. 36MB big. I saw sometimes, its
around 100MB. But in general, they are not exceeding 36MB.

I'm expecting the database to growth, but not much. Maybe about
two-four additional GB's.

My reindexing runs once a week, on sunday. So the shrink (which is not
turned on yet).
What I've observed, since I've changed that, the database is running
much more stable than before it.
Seams to be much faster.

Each transaction log backup takes around 1-5 Seconds. Full Backup now,
takes only 10-12 Minutes togethet with optimisation.
Removing old data, which is done each 10 minutes, takes around 10-20
seconds.
And it all seams to be much better now:)

Regards

Matik

[Back to original message]