Copying Everything to new SQL Server

[DonS100]

I'm building a new SQL Server 2000 box and want to move all my objects(mulitple database, DTS packages, logins, Jobs, backup locations, etc...) from the existing SQL Server 2000 box. What's the easiest way to do this? I see that SQL Server has a copy database wizard but I'm not sure this will bring everything over.

Thanks

 

[tran008]

If it sql2000 to sql2000, just backup the existing sql2000 box and restore them to the new box.

 

[tran008]

You could also try detach and re-attach the db with this link

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071