SQL 2000 has a copy database wizard...

http://support.microsoft.com/default...b;en-us;274463

You can also do it manually.. Even though this article is written specifically about an MIIS database you could do this action to any database running on SQL2000...

http://support.microsoft.com/default...b;en-us;818565

Substitute MicrosoftIdentityIntegrationServer with your database name.


I think moving it manually is a better solution as the copy database wizard is going to create a new database and copy all of the data to that new database, which may take a bit longer.