Recurring: 402: Failed to open local data store: data.sdf

• 
  http://apps.red-gate.com/messageboard/v ... php?t=9243
  
  My instance is SQL 2000, so I couldn't load the SQL Server Compact Edition file into SSMS, so I renamed the troubled file.

  mdgraves August 18, 2010 09:06

  - 0 +
• 
  Thank you for your post and sorry that you have encountered this problem.
  
  During the installation process for SQL Backup Server Components, our install process installs Microsoft SQL Server Compact Edition (SQL Server CE). This action creates a data.sdf file by default (If installing on stand-alone server) in this directory:
  C:\Documents and settings\All Users\Application Data\Red gate\SQL Backup\Data\<SQL Instance Name>\data.sdf
  
  This file act as a cache for the SQL Backup GUI, to improve the performance of the SQL Backup GUI. It is this file that is the Local Data Store.
  
  Can you kindly check following:
  Please check to see if you have a data.sdf present.
  If the file does exist, the file maybe corrupted, please perform the following actions:
  a. Close the SQL Backup GUI
  b. Rename the existing data.sdf, for example to olddata.sdf
  c. Reopen the SQL Backup GUI, this action should create a new data.sdf.
  
  Please let us know how it goes.

  Anu D August 19, 2010 09:07

  - 0 +
• 
  I tried the file rename. All is fine. Thank you for the response.

  mdgraves August 19, 2010 10:28

  - 0 +
• 
  Many thanks for the confirmation.
  
  We are pleased that your issue is resolved.

  Anu D August 19, 2010 10:31

  - 0 +
• 
  Hi there,
  
  We are also getting this error, time and time again. Is there a problem with this cache?
  
  I have fixed the server more than once over about a three week period.

  Daniel_Cave00 January 04, 2011 03:23

  - 0 +

Add comment

Please sign in to leave a comment.