MagarG
VIP Member
I posted some other questions before and now we are closer to actually moving from SQL7 on one server (Server1) to SQL2000 on another server (Server2). I'm trying to get a grasp on the steps to do this. I'm currently looking at a Microsoft article 314546 (How to Move Databases between Computers That Are Running SQL Server).
It looks like in step 1 you have to move the databases either with backup/restore, detach, or import. I was planning on just attaching them. Step 2 you need to transfer logins and step 3 you have to resolve Orphaned users. Step 4 (Move Jobs, Alerts, Operators) and Step 5 (Move DTS Packages) are optional and it looks like we don't have any Jobs, Alerts, Operators, or DTS Packages anyways on Server1.
I was then going to reindex the tables and update statistics. Do I do the reindexing through OMW or SQL or does it matter?
Just wanted to confirm the above process and see if there are any 'gotchas' I should look out for in the steps.
Thanks!
Grant.
It looks like in step 1 you have to move the databases either with backup/restore, detach, or import. I was planning on just attaching them. Step 2 you need to transfer logins and step 3 you have to resolve Orphaned users. Step 4 (Move Jobs, Alerts, Operators) and Step 5 (Move DTS Packages) are optional and it looks like we don't have any Jobs, Alerts, Operators, or DTS Packages anyways on Server1.
I was then going to reindex the tables and update statistics. Do I do the reindexing through OMW or SQL or does it matter?
Just wanted to confirm the above process and see if there are any 'gotchas' I should look out for in the steps.
Thanks!
Grant.