Transferring ACT database from Server 2003 32-bit to Server 2008 64-bit

I am trying to do a Restore As of an exisiting ACT database backup from a 32-bit version of Server 2003 onto a 64-bit version of Server 2008.
I've followed ACT's Installation instructions on the new server.  This is version 11.0 of ACT 2009 Premium.  SQL is SQL 2005 on both servers.  On the Server 2008 that is 64-bit, SQL is installed in 32-bit mode
Both servers are domain controllers of the same domain in active directory, we are actually decommisioning the Server 2003 server.
I have attached the error that I receive....

ACTError.jpg
jy3sonetAsked:
Who is Participating?
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
ZIP files do have problems when >4GB

If the Backup/Restore doesn't work after the maintenance is complete, try moving the database this way:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=23392
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Do you still have the original server running?

If so, can you try a "Restore - As" on the original server?

You might also make sure both systems are running 11.1
0
 
jy3sonetAuthor Commented:
Yes, the original server is running.  We have both servers running simulatnously, as were trying to test ACT on a TEST Server running in a 64-bit OS.

It is running fine on the original server, I don't want to disturb that at all

We haven't put SP1 on either of the ACT installations yet.  Should that be done first?, I didn't see anything significant in the release notes that would affect this.
0
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.

 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Restore_As won't effect the current install - it allows you to select a new name.

You should also try running maintenance first, then re-creating the Backup on the 2003 machine.

Yes, I would upgrade both to 11.1 - or at least the new one.

How big is the ZIP file?
0
 
jy3sonetAuthor Commented:
I'm performing the maintenance tasks on it now.  Our backup file is 18.6 GB though.
0
 
jy3sonetAuthor Commented:
That includes all of the attachments
0
 
jy3sonetAuthor Commented:
I did find an error, and it was repaired.  So I'll be creating a new backup and attempting this again this evening.  Meanwhile try to find the available SP1 update files needed.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
The updates are available from http://www.act.com/support/updates/index.cfm
0
 
jy3sonetAuthor Commented:
Sorry I hadn't replied or commented sooner, as had some issues arrise and had to put this on hold, as I will be working on this again hopefully this week.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Let me know how you go
0
 
jy3sonetAuthor Commented:
Moving the database via this way was the only option.  I may also have a pre-existing schema issues that the database conisitency check tool doesn't repair but will open under a new question.
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.