Thank you for your advice through this process. We ended up doing the following.

After I hit the error rolling forward, I recovered the copy of the database...

I restored the backup by it self and ran CheckDB and it did not find any issues. Then I started restoring T-Log backups and had gotten through about 90%...

So I was restoring the backups to a new copy of the database, I had gotten through almost all of the Transaction log backups, but when I tried to restore...

Thanks for your advice, We are going to try and do a restore and roll the logs forward. It looks like we have all of the backups that we...

Ok, I guess I didn't think about rolling just the logs forward, since the blocks with corruption probably have not changed an so therfore won't be in the log backups....

One More piece of information. At times we have had all connections in the connection pool busy at the same time, does anyone know what happens when it runs...

This is in H24 instead of AM, but maybe this will help.

SELECT (CONVERT( VARCHAR(25), getdate(),103) + ' ' + Convert(VARCHAR(25), getdate(), 114))

TJP8

Sorry, I overlooked that, that format is apparently a Kuwait Standard format, and although the format is how you want it, the date itself does not come out the same.

When...

This should be what you are looking for

SELECT CONVERT(VARCHAR(25), GETDATE(), 131)

GO

You could try something like this

select a.object_id, convert(varchar(25),...

I have found that sometimes a log file in simple mode will shrink without a backup and sometimes it will not. It usually works for me to do the...

It happened again this morning around 5:30. I ran the simple queries from SQL EM and they ended up being blocked by a session coming off of the server....

There have been no error messages on the server in either the SQL Logs or the Event Logs that seem to correlate with this. I definitely will look at...

Another Update, I found the Report Execution Timeout on each report. I tried setting a report to 'Do not timeout report execution' There was no change. I...

Here are two of the timeouts I found. The SSRS site settings Report Execution Timeout was set to 1800 seconds (30 Minutes). I set it to Do not...

Thanks for that information, I just find it sort of odd, that the reports don't seem to be taking any longer to run than they were, but all of the...