moving sms 2003 from SQL 2000 to sql 2005

Posted on 2009-04-23
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

    It would seem MS has outlined the process here.

    Moving the SMS Site Database


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    On a regular basis I get questions about slow RDP performance, RDP connection problems, strange errors and even BSOD, remote computers freezing or restarting after initiation of a remote session. In a lot of this cases the quick solutions made b…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now