move db from sql server 2000 to sql server 2005

how can we manage the db transfer when we are upgrading from 2000 to 2005? what is the right way to do that? where can we find something to read about it?

Hi,

you can simply backup and restore database in SQL 2005 but do remember to update you SQL 2005 Server for Logins. Refer below KB for mroe.

http://www.support.microsoft.com/kb/314546

Hemantgiri S. Goswami