Solved

ACT Database

Posted on 2011-03-11
8
749 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:sterry1950
  • 3
  • 3
  • 2
8 Comments
 
LVL 7

Expert Comment

by:50cal
ID: 35123640
0
 
LVL 7

Expert Comment

by:50cal
ID: 35123653
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.
0
 

Author Comment

by:sterry1950
ID: 35158969
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?
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 35161942
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
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 7

Expert Comment

by:50cal
ID: 35173049
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.
0
 

Author Comment

by:sterry1950
ID: 35200702
I finally had ACT database solutions fix my problem.

Better backups are a must.

Steve
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 35200725
0
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 500 total points
ID: 35200726
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Microsoft CRM issue when using Call cycle 2 530
Outlook 2007 7 387
outlook freezes 11 1,094
Act! version 16 freezing when launched. 8 87
A lot of users new to ACT!, especially those who don't get the benefit of a consultant, seem confused between when to share on a network and when to sync ... or, in fact, how to do either. So I thought I would attempt to explain the various options …
As most of my regular readers and followers know, I do a lot of on-line technical support as well as providing support services to our resellers and ACT! Certified Consultants and one of the things I notice is that I regularly need to ask users the …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now