Solved

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

Posted on 2009-05-05
11
722 Views
Last Modified: 2012-05-06
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
0
Comment
Question by:jy3sonet
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24302763
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
 

Author Comment

by:jy3sonet
ID: 24302781
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
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24302815
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:jy3sonet
ID: 24302832
I'm performing the maintenance tasks on it now.  Our backup file is 18.6 GB though.
0
 

Author Comment

by:jy3sonet
ID: 24302838
That includes all of the attachments
0
 

Author Comment

by:jy3sonet
ID: 24302861
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
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 500 total points
ID: 24302864
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
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24302910
The updates are available from http://www.act.com/support/updates/index.cfm
0
 

Author Comment

by:jy3sonet
ID: 24380986
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
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24383630
Let me know how you go
0
 

Author Closing Comment

by:jy3sonet
ID: 31577928
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

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQLAgent$Act7 servie will not start on act 2009 4 1,713
Export Client Attachments Sage ACT version 11 4 1,325
Act! Pro V16 Email Tracking Feature 5 194
ACT! Premium v17 and Windows 10 3 163
As most of my regular readers and followers know, I do a lot of on-line technical support as well as providing support services to our resellers and ACT! Certified Consultants and one of the things I notice is that I regularly need to ask users the …
Microsoft have a hotfix for Windows systems that will improve application that uses UTC dates and times - including Outlook, the Windows Event Viewer and many third-party applications. Most date and time stamps that are created and displayed in W…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question