I ended up deleting the data connection, recreating it, then updating each report to use the new connection.

Not a pleasant job considering there was 400 reports.

TGG.

Great. Thanks for your help. 🙂

Just out of interest, why would it be best to install the oldest instance version first?

Great. Thanks for all the replies. 🙂

Thanks for the reply.

So I can create a new cluster on the same hardware, but as a 2008 R2 instance.

R.

Cheers! This is just what I was looking for :o)))))

Hi Dave,

Post SP4 for SQL2000? I didn't know there was one. I'll have a look now, but if you could post a link, that would be nice :o)

Cheers.

Hi George,

Would you recommend the below:

SP_CONFIGURE 'max server memory', 20480

RECONFIGURE

GO

This should leave about 4Gb for everything other than SQL.

After I apply the bit of script and restart SQL, should I...

Thanks for your replies. I added the target server memory as you suggested and perfmon shows 12496264 in use which still means s I have nearly half my RAM available....

Hi Mark,

Thanks for the reply.

Performance monitor is ugly! I've looked at the available memory counters but there's not one that shows me memory in use or not an obvious...