Community
Showing results for 
Search instead for 
Do you mean 
Reply

restoring a database - urgent help needed

New Member
Posts: 16
Country: United_Kingdom

restoring a database - urgent help needed

2 days ago I had a catastrophe in that my hard drive decided to die unexpectantly. I have now purchased a new hard drive, installed windows  and am trying to reconfigure everything.  I did not do an official backup of my ACT databases however I did manually copy the database files over to a USB flash drives a few weeks ago.  I have the  ADF, alf ,PAD as well as the database folder.  Logic tells me that I should be able to restore my ACT database from this even though I have not done a backup the official way?  I am using Sage act premium 2011

 

The problem is that when I try to open the PAD or ADF file it does not work.  As suggested when I try to open the ADF file I get the following message:

 

"This database cannot be opened because the SQLServer version of this database cannot be identifed"

 

I am really at a loss as to how I can get my database up and running again?  I am extremely anxious as the database contains nearly 6 months of work and extremely important customer contact details etc.  If anyone knows how I could get this working I would be extremely grateful. If there are no solutions I would even be willing to pay someone to get this working as I am extremely desperate.

Nickel Super Contributor
Posts: 397
Country: USA

Re: restoring a database - urgent help needed

Question, after reinstalling ACT! 2011 and updated to Service Pack 1 and Hot Fix 4, you tried deleting the PAD file and opening the database from ACT! but with the ADF File ??

 

Last question, in the new process installation... was completed successfully the SQL Server 2008 installation and is ACT7 active service??

New Member
Posts: 16
Country: United_Kingdom

Re: restoring a database - urgent help needed

Yes that is the exact process I tried where I delted the PAD file and tried opening with the ADF file but get the message:

 

This database cannot be opened because the SQLServer version of this database cannot be identifed

 

Also I have Hot Fix 4 and according to services.msc "SQL server (ACT7) is an active service."  There is nothing wrong with the SQL server on the new install as I am able to create a new database etc, but I just can't open the old one.