How Upgrade SQL Server/Moving Database on New Machine

[jawan]

I have SQL Server 7 on NT machine. Now we bought Dell Windows 2K server with SP3. I am installing SQL Server 2K on this machine. The question is

How to move all databases on new machine with new OS, and from SQL 7 to SQL 2K.

Thanks in advance.

 

[JayKusch]

You can try running in Query Analyzer sp_detach_db, move your files(MDFs and LDFs) to the new server and then run sp_attach_DB.

You can also use the Detach/Attach options in Enterprise manager also.

Thanks

J. Kusch

 

[Corran007]

To add to what jay wrote...

Dont forget all your jobs, dts packages and users that are on the old machine, you will need to make sure they get moved as well.

But detach and attach works quite well. You will have to use QA to detach the database as it does not work for sql7(its greyed out), but you can use enterprise manager to attach it back.