Thanks Ken.

-- Is it possible that something could be using the backup file? An anti-virus, a copy?

I suppose it is possible something could be running such as anti-virus software? I' will...

Many thanks for that.

As we have used Quest products in the passed it looks like we will be going down that road.

Thanks for all the help guys.

Andrew, we dont have anything at the mo, I was hoping someone here may already be doing this and be able to advise on a third party product or SQL...

Ok, the business requirement is...

"well its more any changes that are made to any table what so ever at any stage. basically a log of what, who and time of...

I am trying to establish what the business requirement is.

At the moment their request is to monitor ANY updates made to the application database. I'm am assuming this may be...

Within the script, this is the initialise log section...

/* Initialise Native Log Backup */

IF @RECOV_MODE <> 'SIMPLE'

EXEC('BACKUP LOG ' + @DB + ' TO DISK = ''' + @LOGPATH +...

I have taken this over from another DBA and so this is a learning curve for me, sorry if I'm not explaining this stuff correctly. As I understand it...

AT 8pm,...

Many thanks for the feedback.

My databases are in FULL recovery mode and I have a Log shipping job running from 8.00am to 19.30 during the day. Then at 8.00pm I...