[Last Call] Learn how to a build a cloud-first strategyRegister Now


moving sms 2003 from SQL 2000 to sql 2005

Posted on 2009-04-23
Medium Priority
Last Modified: 2013-11-21
I have a server with SQL2000 and SMS 2003 SP2.  (let's call it SERVER A)
it's the only SMS server.
I have another server with SQL 2005 (SERVER B).  
We are in the process of moving all the databases from SERVER A to SERVER B
I don't know the process to move the SMS database.
Anyone can help me and give the procesure to move SMS
The servers don't have the same name and I can't rename SERVER B
Let me know if you need more details
Thanks in advance
Question by:adv_expert
1 Comment
LVL 39

Accepted Solution

BrandonGalderisi earned 2000 total points
ID: 24221593
It would seem MS has outlined the process here.

Moving the SMS Site Database


Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found listed in my profile here: http:…
Have you considered what group policies are backwards and forwards compatible? Windows Active Directory servers and clients use group policy templates to deploy sets of policies within your domain. But, there is a catch to deploying policies. The…
Loops Section Overview
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question