Thank you all for the feedback - we'll definitely increase the Memory spec. The backups are dealt with on a separate server.

We are likely to be adding two other databases...

Thanks. The SQL2000 is running on 4 cores at the moment.