• To make things easier you could have a script that runs on a schedule and records data that will be stored in a permanent table. I use the following:

    --HOLDING TABLE FOR DBBC RESULTS

    create table tbl_logspace (

    RecordDate datetime default getdate()

    , DatabaseName varchar(100)

    , LogSizeMB real

    , LogSpaceUsedPct real

    , Status int

    );

    --POPULATE THE HOLDING TABLE WITH CURRENT DATA

    insert tbl_logspace (

    DatabaseName

    , LogSizeMB

    , LogSpaceUsedPct

    , Status)

    exec('dbcc sqlperf(logspace)');

    --VIEW THE CONTENTS

    select * from tbl_logspace;

    This makes it easier to recover data without having to write complex scripts and you can view the Information based on any time range you define.

    Put the INSERT into an Agent Job, schedule it and off you go.....

    Regards,

    Kev