Warning 402: Failed to open local data store:

• 
  Can you please turn on logging for the service by doing the following :
  
  Open regedit and navigate to the following registry key :
  
  HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLBackupAgent(_InstanceName)
  
  Modify the ImagePath value by appending -sqbdebug to the end of the string.
  
  Now please try restarting the SQL Backup Agent.
  
  A log file should be created in the Server Components Installation directory (%:\Program Files\Red Gate\SQL Backup\<instance name> by default).
  
  Could you please send me any log files contained there (support@red-gate.com , subject: F0024635)?
  
  If no log is created, please ensure the SQL Backup Agent Service has permissions to write to the folder where it is located.

  Chris.Allen July 24, 2009 12:39

  - 0 +
• 
  I am having the exact same problem.
  
  What was the resolution?
  
  Thanks!

  SQLDBAsa November 03, 2011 05:07

  - 0 +
• 
  Could you please use Process Explorer or Handle (from Sysinternals/Microsoft) to determine which process is locking the data.sdf file on the server?
  
  Thanks.

  petey November 04, 2011 02:16

  - 0 +
• 
  I fixed this issue on my server.
  For some reason, changing the reg key HKLM\SYSTEM\CurrentControlSet\Services\SQLBackupAgent by adding the -sqbdebug to the end fixed the problem.
  I took the -sqbdebug to the end off the string and it still worked.
  Not sure why this fixed it but give it a try.

  Croix May 13, 2014 16:21

  - 0 +

Add comment

Please sign in to leave a comment.