Link to home
Start Free TrialLog in
Avatar of CCC-Ravens
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_CCCSQLSERVER_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
Avatar of Racim BOUDJAKDJI
Racim BOUDJAKDJI
Flag of Algeria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CCC-Ravens
CCC-Ravens

ASKER

No, Have no clue. I have very little MS SQL Experience so I have no idea what you just said :-) sorry.
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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for the help
Why not backup/restore?
Could not restore to work at all. Backup is fine but could not restore.