How to reset Local Database

Question

How to reset Local Database

StorTropolis - Tiffany Springs 0

My computer is saying local data base must be reset

Viorel 126.8K Reputation points

2026-03-14T04:04:23.43+00:00

In what circumstances does the message appear and what does it look like exactly?
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-03-23T09:53:31.4166667+00:00

Hi StorTropolis - Tiffany Springs,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Thanks,

Lakshmi.
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-03-26T11:31:52.1066667+00:00

Hi StorTropolis - Tiffany Springs,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Thanks,

Lakshmi.

1 answer

Your answer

Viorel 126.8K Reputation points

2026-03-14T04:04:23.43+00:00

In what circumstances does the message appear and what does it look like exactly?
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-03-23T09:53:31.4166667+00:00

Hi StorTropolis - Tiffany Springs,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Thanks,

Lakshmi.
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-03-26T11:31:52.1066667+00:00

Hi StorTropolis - Tiffany Springs,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Thanks,

Lakshmi.

Answer 1

"Local database must be reset" usually indicates that the SQL Server LocalDB instance or its configuration is corrupted.

For LocalDB, the documented action is to fix or delete the corrupted instance and recreate it:

Check for corruption message
- Look in the Windows Application log for events from SQL Server Local Database Runtime with text like:
  - Local Database instance is corrupted. See the Windows Application log for error details.
Delete the corrupted LocalDB instance
- Open a command prompt or PowerShell as Administrator.
- List LocalDB instances:
  - sqllocaldb info
- For the instance that is reported as corrupted (for example MSSQLLocalDB), stop and delete it:
  - sqllocaldb stop MSSQLLocalDB (ignore errors if it is not running)
  - sqllocaldb delete MSSQLLocalDB
Recreate the LocalDB instance
- Still in the elevated command prompt/PowerShell, recreate and start the instance:
  - sqllocaldb create MSSQLLocalDB
  - sqllocaldb start MSSQLLocalDB
- Verify it:
  - sqllocaldb info MSSQLLocalDB

If the corruption is tied to a specific product (for example Microsoft Entra Connect or another app that installs its own LocalDB instance), follow that product’s guidance to remove any corrupt LocalDB files and registry entries, then reinstall LocalDB and recreate the instance before reinstalling the product.

If the instance configuration is so damaged that it cannot be repaired, deleting and recreating the instance is the supported recovery path.

References:

Share via

How to reset Local Database

1 answer

Your answer