0

So I've read some other messages about this and deleted everything in: AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\ProjectsV13

then it all gets re-created. I don't want a local database, but what do I have to do to get rid of this error. This only happens when I open 2017 Visual Studio. Anything I can do.

Dan Parker
  • 823
  • 1
  • 11
  • 27

1 Answers1

1

You might want to try the solution in this answer... Mine was crashing not only on opening VS but also periodically after that. This fixed the issue.

Essentially, MS discovered that this happens only with databases on the localdb server that has the query store feature enabled, and the workaround for now is to disable that particular feature on all of those databases.

Edit: Based on the feedback in the comments below, I'll mention here that I've expanded a bit on the answer in this subsequent response - it helps to prevent the issue from returning when you rebuild your solution.

Peter-John
  • 71
  • 7
  • Yeah, the problem is I have no localdb server. I even tried to install one and that didn't do anything – Dan Parker Apr 21 '17 at 14:15
  • LocalDb is installed as part of Visual Studio 2017... you can access your instances through the "SQL Server Object Explorer" window... `View -> SQL Server Object Explorer` ... then, under the "SQL Server" node, you'll see `(localdb)\MSSQLLocalDB` and `(localdb)\ProjectsV13` – Peter-John May 16 '17 at 01:59
  • 1
    Oh, also, I've expanded a bit on the previous answer in [this subsequent response](http://stackoverflow.com/a/43727455/6641764) - it helps to prevent the issue from returning when you rebuild your solution. – Peter-John May 16 '17 at 02:05
  • The comment post just above seems to be the answer. I had to close and re-open and it seems better now. really strange. thank you – Dan Parker May 22 '17 at 21:49
  • Thanks @dan-parker I've updated the answer to reflect this feedback. If your issue was resolved, please consider marking the answer. – Peter-John Jun 14 '17 at 00:49