Community
Showing results for 
Search instead for 
Do you mean 
Reply

Server crash

New Member
Posts: 7
Country: USA

Server crash

The long and the short of it!!

 

We were running Act 2011 on a Windows 2003 server and got a nasty virus that locked all our files. I have since installled a new Windows 2008 R2 server and reinstalled act. I can get to the SQL database files and need to know how I can restore them to my new act database.

Employee
Posts: 1,163
Country: USA

Re: Server crash

Were you planning to restore from a recent back up or are you using the database files themselves (.adf, .alf)?

 

For the former, you can go to the file menu and choose restore for the latter you can just got FIle -> Open database and change the files of type to .adf. 

 

KB 19818 and KB 23392 respectively. 

Matthew Wood
Act! SDK Support
Community Moderator
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Server crash

You might want to check that you've patched ACT! to the latest Service Pack and Hotfix first ... or at least the one you had before
New Member
Posts: 7
Country: USA

Re: Server crash

I cant bring the sql server backup on the old 2003 server. Can I get the data from the SQL directy of the old system?

Employee
Posts: 1,163
Country: USA

Re: Server crash

[ Edited ]

SQL Server is just the database server, it doesn't actually contain any data. All of the data in your Sage Act database is found in the .adf file other than the contents of your supplemental files (attachments). This would all be included in a backup of the database.

Matthew Wood
Act! SDK Support
Community Moderator
New Member
Posts: 7
Country: USA

Re: Server crash

OK I found the .adf file now I can restore it?

 

Employee
Posts: 1,163
Country: USA

Re: Server crash

As I mentioned in my previous post, take a look at KB 23392, it describes the process for moving a Sage Act database without doing a backup and restore, which is the preferred method.

Matthew Wood
Act! SDK Support
Community Moderator
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Server crash

Note ... you need more than just the ADF. You need:
(Database name).ADF
(Database name).ALF
(Database name)-database files ... this is a folder.

You don't need the PAD file
New Member
Posts: 7
Country: USA

Re: Server crash

Almost there. Its saying invalid user name and password. Where would I add that

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Server crash

Your username is usually: Firstname Lastname
If you never needed a password, try leaving it blank