do anyone know how to migrate a mssql 2000 server (running windows 2003) to
another server which is running windows 2003 also, what are the procedures
to do so?
ok thanks
Generally you would install SQL in the same location on server 2 as you did in server 1. ShutDown SQL on both servers and copy of the data directory that contains your mdf and ldf files to the same location on Server2.
This is a very generic answer of course. If you need to change locations and such then it would be more complex.
Make sure that you have the service packs installed also.
Jeff
MCDBA, MCSE+I
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment