sterry1950
asked on
ACT Database
I have an ACT 2008 Premium database that will not open. While verifying the .adf i get the error message "The Log scan number passed to ...."
I can get the file open in SQL Recovery but after saving it still won't open in ACT and is not seen by SQL server management express.
Any suggestions?
I can get the file open in SQL Recovery but after saving it still won't open in ACT and is not seen by SQL server management express.
Any suggestions?
In Act 2011 there is a tool in Act diag to attach a Adf file without the alf(log) file, this feature is not available in earlier versions which could be why the link in my previous post suggest contacting sage as there is a standalone application that can do that for earlier versions.
50cal.
50cal.
ASKER
I downloaded and installed ACT 11 on an unused machine and copied the damaged database over to it.
The database would not open with the message 'The lod scan ...
I loaded actdiag in act 11 and tried to attach to the database without the log file but still had no success. A general message about transaction logs and log files comes up.
Any other suggestion?
The database would not open with the message 'The lod scan ...
I loaded actdiag in act 11 and tried to attach to the database without the log file but still had no success. A general message about transaction logs and log files comes up.
Any other suggestion?
By ACT! 11, do you version 2011 (v13) or 2009 (v11)?
Also, it wouldn't be able to convert the file if it's damaged and you probably should get Sage Database Services to fix it for you
Also, it wouldn't be able to convert the file if it's damaged and you probably should get Sage Database Services to fix it for you
If you try renaming the log file or moving the log file out into another folder and then attaching the ADF via ActDiag (Act 2011 only).
Start -> Run (or type in the search box)
Type ActDiag and Press OK
Select "Tools -> Attach Act Database -> Missing Log File"
Browse to and select the Database ADF file and press OK.
50cal.
Start -> Run (or type in the search box)
Type ActDiag and Press OK
Select "Tools -> Attach Act Database -> Missing Log File"
Browse to and select the Database ADF file and press OK.
50cal.
ASKER
I finally had ACT database solutions fix my problem.
Better backups are a must.
Steve
Better backups are a must.
Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=14494&p_created=1120440234&p_sid=DLHAURok&p_accessibility=0&p_redirect=&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9OTc4LDk3OCZwX3Byb2RzPTAmcF9jYXRzPSZwX3B2PSZwX2N2PSZwX3NlYXJjaF90eXBlPWFuc3dlcnMuc2VhcmNoX25sJnBfcGFnZT0xJnBfc2VhcmNoX3RleHQ9VGhlIExvZyBzY2FuIG51bWJlciBwYXNzZWQgdG8*&p_li=&p_topview=1
50cal