SQL Server 2000 question

[groovin]

as the summary states, can you move a db on a SQL Server 2k sp2 to an sp3 server? how about sp4? Or does the current SQL server need to have the same sp number? the original machine is NT4 while the new is win2k3

thanks

 

[Wizkid]

Just make a backup on one server and then restore it on the next. I'm pretty sure it will work fine.

Try one and see

 

[JCKC]

You can either run a backup & restore as mentioned previously, or you can use DTS to migrate the source database to the destination server.

 

[groovin]

thanks for the replies...

as for making a backup, im guessing that using the SQL Server backup does a 'hot' backup which doesnt take the db offline during the backup?