Post reply

Full Migration of sqlserver 2005 from one server to other server

  • September 18, 2009 at 3:37 pm

    #215497

    hi

    i want to do full migration of sqlserver 2005 from one machine to other machine due to some technical issues.

    1) i want to migrate everthing (db's,sp,trig,jobs,ssispackages etc) in to the new server.

    2) i want to migrate all reports from reporting server.

    can any one guide me on this one

    Thanks in advance

    Rock..

  • September 18, 2009 at 5:34 pm

    #1055902

    Kindly let me know are you installing a new instance in the server, or you want to migrate system DB's also.

  • September 19, 2009 at 2:42 am

    #1055929

    I want to migrate all databases,sp's,jobs,ssis packages,reports etc of sqlserver 2005 from one machine to other machine.

    please guide me on this one

    Regards

    Rock...

  • September 19, 2009 at 5:00 am

    #1055938

    Wow! Your question requried very big and detailed answer.

    If you google "how to move sql server 2005" you get more than 2 million results.:-)

  • September 19, 2009 at 12:45 pm

    #1055974

    As for option 2) reporting services I highly recommend you follow KB article 842425.

    Answering question 1) is a big subject with many options. how much data are you moving? how many databases, how many SSIS packages? How many sQLAgent jobs? Is the new server already built, will it have a new name or do you intend to rename the server to the same as the original after copying the data over? Are you using replication in the current system? How much of an outage can you afford during the failover?

    ---------------------------------------------------------------------

  • September 19, 2009 at 2:04 pm

    #1055983

    As George said, the answering the question 1) is a big subject with many options.

    But you were asking about guide.

    So, the brief and a general guide is here. Remember, it is not step-by-step instruction.

    1. Install SQL Server to another machine using Microsoft Best Practices

    2. Apply the latest Service Pack (SP3 for SS2005) and the mandatory security updates

    3. Adjust SQL Server configuration (memory, ports, affinity mask, TempDB files number, etc.)

    4. Backup all user databases on the old server and then restore them on the new one. You can also use Detach-Attach method or the Copy Database Wizard.

    5. Script all jobs, logins, operators, alerts on the old server and re-create them on the new one by running these scripts.

    6. If you have the Maintenance plans - just re-create them, because you cannot script them.

    7. Migrate all SSIS packages to the new server

    Of course each step itself has a lot of details.

  • September 21, 2009 at 1:55 pm

    #1056471

    i am bit worrying about the reports. remaining things i can handle it.

    can any one tell me how to migrate all reports and their corresponding users to a new server.

    Thanks every one

  • September 22, 2009 at 2:40 am

    #1056617

    Kindly go through the below link to Migrate Reporting services & its report

    http://msdn.microsoft.com/en-us/library/ms143724(SQL.90).aspx

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply