Moving SQL2k5 to a new Server

Posted on 2009-12-17
Medium Priority
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

Aneesh Retnakaran earned 2000 total points
ID: 26073738
you can save the ssis files into the disk and import it on the other machine

Author Comment

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

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

807 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