I need to migrate an old SQL 2000 database, setting on a windows 2000 server, to a SQL 2008 setting on a 2008 server OS (different server).
I have a backup of the database with me (which I got by using a db full backup. The database size is 50 GB.
What's the best way to do this?
Never mind. I was able to do it . It's straight forward restore with replace.