We have resolved the problems as follows although this doesnt address why the problem occurred in the first place:

We used MOm to monitor the increase in cpu usage by the...

let me add my name to the list of dissenters!

RS has a DTS package called RSExecutionLog_update which enables data to be extracted from the ReportServer db into more user friendly format. This package comes on the install disc.

When this...

Two points:

1. We have recently started to use a 3rd party backup product which compresses the backup and so removes the need for zip and unzip. This makes the backup...

We had a problem with restores not working for large databases when we first moved to SQL 2000. The restores were run on a standby server but were initiated from a job...