How to migrate an SQLServer 2000 database from one machine to another
- by Saiyine
This January I'm migrating our main SQLServer 2000 based database to a beefier server. Is there any standard procedure or documentation on how to do it? I need to replicate all at the new server (databases, jobs, DTSs, vinculated servers, etc).
Edit: I mean SQLServer 2000 on both ends!
Edit: Be calm, people, I just crossed the versions from another software I posted about at the same time as this.
Effectively, I even checked the wikipedia to be sure version 8 was 2000. Don't need to flame that much about what is just an errata.