Sql Backup Service will not start

Comments

• Eddie D Redgate › Posts: 1,803 Rose Gold 5

  January 23, 2009 12:42PM

  Thank you for your post and sorry that you have encountered this problem.
  
  When the SQL Backup Server components are installed, a registry key is added for each instance which has the path to the SQL Backup Agent executable.
  
  For a named instance, the path should end with '-i <SQL Instance Name>', for some reason this parameter does not get added to the path and this is what I suspect has occurred.
  
  Can you please check the following registry key for each SQL Backup Server Components installation to see if it has the '-i <SQL Instance Name>' parameter at the end of the path.
  
  HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLBackupAgent_<InstanceName>
  
  You should see two folders, one for each instance.
  
  Locate the ImagePath Key in each folder which is a REG_SZ type, check the data path and ensure that it has the '-i <SQL Instance Name>' parameter at the end of the path.
  
  If it does not have the '-i <SQL Instance Name>' parameter, please modify the ImagePath key and add the '-i <SQL Instance Name>' parameter to the end of the path.
  
  Missing the '-i <SQL Instance Name>' parameter:
  

  C:\Program Files(X86)\Red Gate\<InstanceName>\SQBCoreService.exe
  

  
  With the '-i <SQL Instance Name>' parameter:

  C:\Program Files(X86)\Red Gate\<InstanceName>\SQBCoreService.exe -i <SQL Instance Name>
  

  
  You may need to re-boot the server so that the change takes effect.
  
  I hope that the above advice resolves your problem.
  
  PLEASE NOTE The above advice only occurs on SQL Servers Instance's that are a named instances. The default or (local) instance do not require the '-i' parameter.
  
  Many Thanks
  Eddie

  Eddie Davis
  Senior Product Support Engineer
  Redgate Software Ltd
  Email: support@red-gate.com

  0 · Share on Twitter
• Toeho Posts: 73

  January 23, 2009 3:19PM

  That was it - Thanks

  0 · Share on Twitter