One additional piece of information. I looked at a third shared schedule we use for monthly reports. Interestingly this schedule did run on 1/1 around the same time as the...

Hi Lynn,

Thanks for your response. Here's the job scripts for the two schedules I mentioned. I wasn't aware that the underlying jobs were managed by SQL Server Agent so I've...

Hi Luke, thanks for your response. I granted the end-user the privileges necessary to create new snapshots. I foolishly thought that would be the end of it. What I was...

Just a quick update....after disabling the disk defrag tool the DBCC CHECKDB command was successful. So it looks like we have identified the culprit.

Thanks for your help.

Chris.

Thanks for the suggestion/advice. I'll disable the defrag tool on that volume and try the CHECKDB command again.

Regards,

Chris.

First, thanks for the reply.

Unfortunately I don't see anything helpful in the Windows system event log. I've pasted the full content of the pertinent windows (Application) event log entries below....

I may be oversimplifying a bit (okay a lot) but after the backup has finished reading data it circles back to the log and looks for any transactions committed that...

Thanks...I appreciate the response and explanation.

I appear to have the same problem. DBCC CHECKDB identifies 2 pages with errors. From there DBCC PAGE identifies objID=2 and indexID=255 (tsysindexes) index.

I would be very interested to learn...

Thanks to all for your responses and suggestions, I really appreciate it.

I was just about to post a very similar question about creating a pivot table with "dynamic" column names when I found this thread. Thanks to all who contributed! In...

Thanks for the advice. We tried the download but still no luck. Will we also need a 64bit ODBC driver?