Moving SQL2k5 to a new Server

Posted on 2009-12-17
Last Modified: 2012-05-08
I have a Win2k3 box with SQL2k5 on it. The machine is going to be decommissioned. I have to move the db, the SQL Server Agent Jobs, the triggers, the stored procs, and the rest of it to a new machine with Win2k8 and SQL2k5.

The "Copy Database..." task worked pretty well but the jobs fail on the 2k5 box because the SSIS packages fail. The SQL statements I've written in the job doesn't fail.

What is the best suggestion on how to move this setup, please.

Question by:garyoh
    LVL 75

    Accepted Solution

    you can save the ssis files into the disk and import it on the other machine

    Author Comment

    Really?! Okay, will it try that and see.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    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…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    731 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

    15 Experts available now in Live!

    Get 1:1 Help Now