04-04-2012 09:05 AM
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.
04-04-2012 09:10 AM
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.
04-04-2012 09:24 AM
04-04-2012 09:45 AM - edited 04-04-2012 09:46 AM
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.
04-04-2012 09:55 AM
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.
04-04-2012 10:05 AM
04-04-2012 10:45 AM