Act 9 for Workgroups wont restore

Hi, I have not tried to restore on the W2008 server yet, so not that.  

The ADF is 700Mb and the attachments are 8GB

The limit of a ZIP file is 4GB
Later versions of the Backup allow you to backup without the attchments

You might try the BAT file for backups mentioned:
http://www.experts-exchange.com/articles/Database/Contact_Management/ACT/Automating-backups-for-ACT-by-Sage.html

Thank you very much for this.  At least I know the reason why and I have been able to successfully restore to the new server, however I cannot get my client's to connect to the database in the new location.

I have shared out the location of the database and I can click on the .pad files from the client but then the client gives me a message 'could not find a database called <DATABASE NAME> on host <CLIENT WORKSTATION NAME>

Any ideas?

How did you copy the database?
If you did it via the BAT, the PAD file will still point to the old location

The PAD is just a Pointer to the ACT! Database - you can open it in Notepad to see what machine it points to.

If it's wrong, delete the PAD
In ACT! - File Open
Change File Type to ADF
Open the file and it will create a new PAD

You might find this useful: http://blog.glcomputing.com.au/2009/02/sharing-act-network-or-sync.html

I renames the attachements folder so they were not backed up and then backed up and restored within act.  We will bring the attachements over manually later.

Looked at the pad file, seemed fine but I tried put the mapped drive details in instead of the location on the server drive, but this did not work


<?xml version="1.0" standalone="no"?>
<!DOCTYPE ACTDatabasePADFile>
<!--This file represents a Pointer to an Act Database or [PAD]-->
<ACTDatabase name="ADSM" host="." location="\\Appserver\ACTDATASQL\ADSM.ADF" type="Sql" />

Ok,

I have looked at the old pad and updated:

<?xml version="1.0" standalone="no"?>
<!DOCTYPE ACTDatabasePADFile>
<!--This file represents a Pointer to an Act Database or [PAD]-->
<ACTDatabase name="ADSM" host="APPSERVER" location="D:\ACTDATASQL\ADSM.ADF" type="Sql" />

This now lets me log in but then says it requires the supplemantal information, so I am restoring the attachments and see if that works.

You selected "Restore As" when doing the restore?

That PAD won't work
host should be the machine name or IP
location should be the physical location drive:\Path

Delete it and re-create as above

Host is APPSERVER, I tried deleting the pad file and recreating it but when I selected the ADF option it stated that I do not have access, but I am local admin.  

Exact error?

Cannot find database supplemental files folder ADSM-database files in this location APPSERVER.  This could be a problem with the share, or the folder may not exist.  Please contact the administrator of your database

I am now restoring all folders under adsm database files, (Backup, Layouts, Queries, Reports & Templates)

Yup, you need them there...

Then check this:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=19876

When I went to restore it would seem that the files are already there from the backup.

Reading through the article it looks like sharing is not setup and when I login to the database, tools...database maintenance...share database  is grayed out, but I am logging in as a full administrator.......

Got it working!!

We had to share the database as described above and to get this grayed out option available we had to diable UAC.  

Many many thanks for sticking with this and your assistance.