Hi.
You'll need to restore your backup to a SQL 2005 instance. From there you could generate script to recreate all of your tables, views, stored procs, triggers, functions, constraints, etc. Then use DTS from SQL 2000 (or SSIS from 2005) to transfer the data - you could also use bcp or a similar utility or set up one server as a linked server from the other and insert the data that way. In any case, transfer the data before creating your foreign key constraints to make life easier