Options

The system cannot find the file specified.

gsc_ghxgsc_ghx Posts: 73
edited January 7, 2011 12:35PM in SQL Backup Previous Versions
I am trying to upgrade a 2008 R1 SQL Server to BAckup 6 and am getting this error when trying to start the Redgate Service.

Error msg
The SQL Backup Agent-ODOP service failed to start due to the following error:
The system cannot find the file specified.

Here is the information from event viewer log.
System
- Provider
[ Name] Service Control Manager
[ Guid] {555908d1-a6d7-4695-8e1e-26931d2012f4}
[ EventSourceName] Service Control Manager
- EventID 7000
[ Qualifiers] 49152
Version 0
Level 2
Task 0
Opcode 0
Keywords 0x8080000000000000
- TimeCreated
[ SystemTime] 2011-01-06T22:16:38.870541000Z
EventRecordID 30421
Correlation
- Execution
[ ProcessID] 508
[ ThreadID] 8884
Channel System
Computer ODOPSQL01-S.xxxx.xxx.com
Security
- EventData
param1 SQL Backup Agent-ODOP
param2 %%2

Any help here would be appreciatedl Thanks - Geri
· Share on Twitter

Comments

  • Options
    peteypetey Posts: 2,358 New member
    In the Windows Service Manager, select the SQL Backup Agent service for the ODOP instance. Open the properties for that service. Does the file actually exist in the 'Path to executable' property?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • Options
    gsc_ghxgsc_ghx Posts: 73
    Hi Peter - the file does exist on the drive specified in that path. I checked and my logon users have read write to that path.

    Thanks...

    Geri
    · Share on Twitter
  • Options
    peteypetey Posts: 2,358 New member
    Does the SQL Backup Agent service startup user have read/write rights to that directory? Quickest way to check would be to just set the service startup user to LocalSystem and see if the service can be started.

    If that fails, could you please check if a file named zlib1.dll is present in the same directory that SQBCoreService.exe is located?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • Options
    gsc_ghxgsc_ghx Posts: 73
    Peter - that file was not there. So I decided to uninstall what was installed and reinstall. All is good now.

    Thank you for your help. It has been greatly appreciated. :D

    Geri
    · Share on Twitter
Sign In or Register to comment.