• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

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.
0
CCC-Ravens
Asked:
CCC-Ravens
  • 5
2 Solutions
 
Racim BOUDJAKDJIDatabase 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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
CCC-RavensAuthor 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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now