inclement

autodefenestration

Steve,

Another super fast reply, thanks.

I reckon my question regarding the system databases was due to my brain being somewhat full up at the moment, could do with a holiday!

I've got...

Mark

Thanks for the super fast reply, I'll add the bits you have suggested to my "just do it " script. I'm still scratching my head regarding what if anything...

In response to MattieuQ's reply;

Amend the update statements to the following

update #Files set [FileName] = substring (RawData, 40, 255) where FilePath is NULL

update #Files set FileSize = convert(decimal(18, 2),...

The last report (report 4) must be wrong, backup file names are not recorded in sysaltfiles

-- REPORT 4: POTENTIAL SPACE SAVING (DETAILED) REPORT (FOR .BAK/.UBAK FILES), FROM BIGGEST TO SMALLEST...

Many thanks

declare @birthday datetime

declare @ToDate datetime

DECLARE @smonth TINYINT, @sday TINYINT, @syear SMALLINT

DECLARE @emonth TINYINT, @eday TINYINT, @eyear SMALLINT

DECLARE @months TINYINT, @days TINYINT, @years SMALLINT

DECLARE @tdate SMALLDATETIME

set @birthday = '15 feb...

The job has been running for a long time.

On the server we see

ErrorLog

ErrorLog.1

ErrorLog.2

ErrorLog.3

ErrorLog.4

ErrorLog.5

ErrorLog.9

ErrorLog.10

ErrorLog.11

ErrorLog.12

ErrorLog.13

ErrorLog.14

and ErrorLogTemp

Provided by bit of doohickery has got me the min and max dates from each file the...

Steve,

5 and 9 follow on, 4 and 5 don't, or so it appears. I am checking the individual logs for the missing entries. We operate a 24/7 business,...

Terry, cannot see the missing logs anywhere.

Steve, the sequence of the logs on one server as an example is

Current log 09 april 00:13 hrs to present

archive #1 08 april 18:07...

The job is scheduled to run everyday (including weekends)

Recycles everyday around 00:00 hrs

The login process is straight from the client to the database, nothing in the middle(no application server)

There doesn't look to be much going on on the server, no bulk loading, there are a load of Login succeeded messages but that is about it