• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

SQL Server 2000 question

G

groovin

Senior member
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
 
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 😉
 
You can either run a backup & restore as mentioned previously, or you can use DTS to migrate the source database to the destination server.
 
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?

 
You must log in or register to reply here.

TRENDING THREADS

Back
Top