Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

This January I'm migrating our main SQL Server 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).

share|improve this question
2  
What is a "vinculated server"? –  joeqwerty Dec 30 '10 at 18:31
    
Sorry if in the English version is called in another way, maybe is called Linked servers or something like that. Those are other databases, wich can be from other vendors, that you can query from withing SQLServer if it's configured as needed. –  Saiyine Dec 30 '10 at 19:44
    
The english name is "linked servers". –  Massimo Dec 30 '10 at 19:58

1 Answer 1

There are things that you can migrate quite easily (databases) and things that require a lot more works (security, jobs). There is no "standard" procedure for migrating everything in a single step: each thing needs to be migrated differently.

My suggestion is to look for a qualified DBA, who will be able to properly understand what needs to be done and then do it.

share|improve this answer
    
In fairness, @joeqwerty, he said "year-based versions". –  user3914 Dec 31 '10 at 2:58
    
+1 for the phrase "qualified DBA". –  user3914 Dec 31 '10 at 2:58

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.