This is a poorly written information request. I realized that with some of the responses. I did specify a side-by-side scenario initially but botched from there. Even in my last response - did it again. I do try to be careful however this came up way too short. My apologies to everyone.

Very simply - I want to move SQL Server 2000 databases to a SQL Server 2008 (side by side).

Not only consolidate the servers to one but upgrade the environment. Some of the SQL 2000

instances are on Windows 2000 - there's no support for the OS.

Copy SQL Server 2000 backup to the SQL Server 2008 instance. That'll do it.

My apologies to everyone again.