I want to upgrade from MS SQL Server 2000 to 2005. I have the backup file of the current database in 2000. How can I restore (or other way) 2000 database to new 2005 database? I want to keep the tables, views, relationships, data, triggers, procedures, index... Is it possible to do that? Or any walkaround?