• Hi Bev,

    Have you treble-checked :-). I'm pretty sure one of those 399 rows must have a value of 2 (active). As soon as you create a database, some info gets written to its log file and one of the VLFs will be active.

    USE master;

    go

    CREATE DATABASE NewTest;

    USE NewTest;

    go

    DBCC LogInfo;

    As for space resue - this does require a log backup if the database is in FULL recovery model, but not in SIMPLE.