CCC-Ravens
asked on
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 _CCCSQLSER VER_7" failed. Event ID is 12291 Source is SQLISPackage100. could some one please help me get my database copied to my new server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help
Why not backup/restore?
ASKER
Could not restore to work at all. Backup is fine but could not restore.
ASKER