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 thanksGenerally 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 th
at 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 an
d such then it would be more complex.
Make sure that you have the service packs installed also.
Jeff
MCDBA, MCSE+I
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment