Can't Copy a MsSql Database From one SQLserver 2008 R2 to another

Posted on 2011-10-19
Last Modified: 2012-05-12
I have been trying to get my MS SQL Server 2008 database on a 32bit Server  to a new 64bit Server also having MS SQL Server 2008 R2 Installed. I finally got all the databases to copy but one. It goes through 4 of 5 successes and than after some time it errors out with Job Failed. Check the event log on the destination for details. All the event viewer says is Package "CDW_Jenzabar_CCC-JENZABAR_CCCSQLSERVER_7" failed. Event ID is 12291 Source is SQLISPackage100. could some one please help me get my database copied to my new server.
Question by:CCC-Ravens
    LVL 23

    Accepted Solution

    check the data source of the dtsx data sources and verify for what reason it fails.  I hope you know how to edit a package.

    Author Comment

    No, Have no clue. I have very little MS SQL Experience so I have no idea what you just said :-) sorry.

    Author Comment

    I tried another way, I tried to export and import the damn thing and here is the log file i got as it still didn't work. mssql-report.txt

    Assisted Solution

    Created a new DB on new server and did a SQL dump to it and it seems to have moved the data to the DB I created.

    Author Closing Comment

    Thanks for the help
    LVL 39

    Expert Comment

    Why not backup/restore?

    Author Comment

    Could not restore to work at all. Backup is fine but could not restore.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    This tutorial will walk an individual through the process of upgrading their existing Backup Exec 2012 to 2014. Either install the CD\DVD into the drive and let it auto-start, or browse to the drive and double-click the Browser file: Select the ap…
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    759 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

    13 Experts available now in Live!

    Get 1:1 Help Now