jy3sonet
asked on
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
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
ASKER
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.
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.
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?
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?
ASKER
I'm performing the maintenance tasks on it now. Our backup file is 18.6 GB though.
ASKER
That includes all of the attachments
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
The updates are available from http://www.act.com/support/updates/index.cfm
ASKER
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.
Let me know how you go
ASKER
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.
If so, can you try a "Restore - As" on the original server?
You might also make sure both systems are running 11.1