I have a database in sql server 2000 and need to backup and restore it onto sql express 2005 which is installed on the same server.

I was hoping I could just backup the sql server 2000 db and restore it but that doesn't seem to work.

Anyone have any ideas ?

TIA