Sometimes you may need to clean out your LocalDB installation. For example, perhaps you need to delete all databases and create new ones. When you do not have access to SQL Server tools such as Microsoft SQL Server Management Studio,there is a command line tool that can be used instead.
Warning!
This procedure will delete all databases that are part of a LocalDB installation.
Step-by-step guide
If you are experiencing problems connecting to your LocalDB installation, creating a demo database on your LocalDB installation, or if you just wish to start fresh, follow the guide below:
- Open a command prompt as administrator
List the LocalDB instances using the command:
sqllocaldb i
By default, LocalDB is created by Jiwa with an instance called "MSSQLLocalDB". Stop the selected instance:
sqllocaldb p MSSQLLocalDB
Delete the selected instance:
sqllocaldb d MSSQLLocalDB
Recreate the selected instance:
sqllocaldb c MSSQLLocalDB
Start the newly created instance:
sqllocaldb s MSSQLLocalDB
You should now be able to use the Jiwa Database Manager to create a new demonstration database on LocalDB. See here for more information.
Related articles