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

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.
CCC-RavensAsked:
Who is Participating?
 
Racim BOUDJAKDJIConnect With a Mentor Database Architect - Dba - Data ScientistCommented:
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.
0
 
CCC-RavensAuthor Commented:
No, Have no clue. I have very little MS SQL Experience so I have no idea what you just said :-) sorry.
0
 
CCC-RavensAuthor Commented:
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
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
CCC-RavensConnect With a Mentor Author Commented:
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.
0
 
CCC-RavensAuthor Commented:
Thanks for the help
0
 
BrandonGalderisiCommented:
Why not backup/restore?
0
 
CCC-RavensAuthor Commented:
Could not restore to work at all. Backup is fine but could not restore.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.