Wednesday, April 5, 2017

LOCAL DB Check and commands

To check Local DB installed
[HKLM\SOFTWARE\Microsoft\Microsoft SQL Server Local DB\Installed Versions\11.0
SqlLocalDB can be found in
C:\Program Files\Microsoft SQL Server\110\Tools\Binn
or
C:\Program Files\Microsoft SQL Server\120\Tools\Binn


Server Local DB\Instances\v11.0), and type:
Delete Local DB

  • sqllocaldb delete "v11.0" 

Create Local DB

  • sqllocaldb create "v11.0"
Start Local DB

  • sqllocaldb Start "v11.0" 

--LocalDB instance "v11.0" created with version 11.0

Check Local DB status

  • sqllocaldb Info "v11.0" 









No comments:

Post a Comment

Note: Only a member of this blog may post a comment.