Like most technical questions, the answer will vary based on a number of issues. If all things are equal, ie the SQL versions are the same (SQL 7 or SQL 2000) and the backup devices are compatible, it is as simple as doing a full SQL backup from the old server and restoring it to the new server. If restoring the file groups to their original location, ensure the drives and folders exist, or you can modify the paths for each filegroup in the restore options tab (when using Enterprise Manager). You will need to check user security settings to allow access to the DB on the new server. Check for "orphaned users" in the new DB - these are user logins that had access on the old server but no longer exist on the new server. This is a very basic overview that works when moving a DB from SQL 7 to SQL 2000 as well, but cannot be used for SQL 6.5 DB's. Another point to consider is how client applications get their connections to the data. If the new server name is different, this may cause further complications and may require a more in depth plan, for both the servers and clients, to move the DB. The microsoft support web site has a lot of good documentation on how to do this. Search for articles on upgrading to SQL 2000.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
migrate SQL from one server to another