Hello again,

I've created a new LS but with different restore times. So instead of 15 minutes it's now on 5 minutes. Might be useless but nothing like testing.

I got a...

Hello,

Confirmed the problem with Legato.

Did a new LS on a server that are not on the backup schedule and no errors so far.

Will check the Legato Script but this...

I'm afraid I can't run a Profiler on this Production DB. Just too big and I can't afford slowing down the processes at this time.

Will try to check the back...

No errors or Truncate on the Logs.

Tomorrow I will have a final report from the Backup Team, but so far I can't seem to find a logical reason behind this...

Ellis RemoteDBA (6/17/2008)

---

have there been any addition SSIS/DTS Imports taken place, have you created/rebuilt any indexes. Does your db grow automtically? if so could the automatic expeansion have taiken this...

Hello,

just confirmed the error. It started going Out of Sync at 6:15AM and got the first Event Error at 7:00AM.

So it really seems to be something with the Online Backup.

Strangely...

Strangely It failed again at 6:45AM. (Online Backup starts at 5:00AM).

Will try to get some more info and will get back to you.

Appreciate your patience.

Hello again,

I've been using No Recovery Mode on the Secondary Transaction Log.

Do you recomend placing it on Standby Mode with the Disconnect users in the database when restoring backups activated?

I...

Thank you once again George.

I'll check if our backup software is using SQL agent.

Nevertheless I did another test that might prove that the problem isn't the backup procedure but something...

Thanks George, that was my idea as well.

Do you have any recommendations in the way to avoid the Truncate of the DB?

Thank you in advance.

I did a test to check if the error would happen again.

Placed LS doing its normal job until a certain time. After an hour it would resume LS again.

Still...

Hello,

I'm talking on Server Backups, not SQL.

So, when doing a full Online Server Backup something happens that messes around with LS and it starts getting an Out of Sync message...

Hello,

it's an Online Backup during the week and one Offline Backup made on Sundays.

I suspect that the Backup process interferes with LS by doing a Truncate on the Logs when...