Solved

SQLAgent$Act7 servie will not start on act 2009

Posted on 2010-11-30
4
1,686 Views
Last Modified: 2012-06-21
Hello,

I'm using Act 2009 on my laptop. Yesterday my computer crashed and since then act won't load my data

I have looked in service manager to find out that the SQLAgent$Act7 service was not started and I could not start it manually. I get error 3414

Please help.... do I need to reinstall act or msde or both... will I lose my data?

0
Comment
Question by:precicom
  • 3
4 Comments
 

Author Comment

by:precicom
ID: 34242095
Here is the sql error log:

2010-11-30 09:22:25.68 Server      Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)
      May 26 2009 14:24:20
      Copyright (c) 1988-2005 Microsoft Corporation
      Express Edition on Windows NT 6.0 (Build 6002: Service Pack 2)

2010-11-30 09:22:25.70 Server      (c) 2005 Microsoft Corporation.
2010-11-30 09:22:25.71 Server      All rights reserved.
2010-11-30 09:22:25.71 Server      Server process ID is 3260.
2010-11-30 09:22:25.71 Server      Authentication mode is MIXED.
2010-11-30 09:22:25.71 Server      Logging SQL Server messages in file 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-11-30 09:22:25.71 Server      This instance of SQL Server last reported using a process ID of 4956 at 2010-11-29 14:39:07 (local) 2010-11-29 19:39:07 (UTC). This is an informational message only; no user action is required.
2010-11-30 09:22:25.71 Server      Registry startup parameters:
2010-11-30 09:22:25.71 Server             -d C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-11-30 09:22:25.71 Server             -e C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-11-30 09:22:25.71 Server             -l C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-11-30 09:22:25.93 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-11-30 09:22:25.93 Server      Detected 2 CPUs. This is an informational message; no user action is required.
2010-11-30 09:22:27.52 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2010-11-30 09:22:30.44 Server      Database mirroring has been enabled on this instance of SQL Server.
2010-11-30 09:22:30.45 spid5s      Starting up database 'master'.
2010-11-30 09:22:30.83 spid5s      SQL Trace ID 1 was started by login "sa".
2010-11-30 09:22:30.89 spid5s      Starting up database 'mssqlsystemresource'.
2010-11-30 09:22:30.97 spid5s      The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
2010-11-30 09:22:31.66 spid8s      Starting up database 'model'.
2010-11-30 09:22:31.66 spid5s      Server name is 'PC-DE-DANIELMOR\ACT7'. This is an informational message only. No user action is required.
2010-11-30 09:22:31.66 spid5s      Starting up database 'msdb'.
2010-11-30 09:22:31.94 spid8s      Error: 9003, Severity: 20, State: 1.
2010-11-30 09:22:31.94 spid8s      The log scan number (28:304:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
2010-11-30 09:22:31.94 spid8s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 34246592
Can you open ACTDIAG, look at the database list and see if any of the databases are marked as "Suspect"?
0
 

Accepted Solution

by:
precicom earned 0 total points
ID: 34248251
The problem was with the model databse, so I copied the model database files from another server installation and the problem was solved

thank you
0
 

Author Closing Comment

by:precicom
ID: 34281055
I solved the probleme my self
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Microsoft have a hotfix for Windows systems that will improve application that uses UTC dates and times - including Outlook, the Windows Event Viewer and many third-party applications. Most date and time stamps that are created and displayed in W…
As owner of GL Computing, I have worked with CRM products since 1984 and with Act! since 1987.  GL Computing provides training and technical support to Act! Consultants, resellers and add-on developers around the world. One of the problems we not…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

707 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

12 Experts available now in Live!

Get 1:1 Help Now