Management LocalDB
1. Sqllocaldb commandAfter the installation, you can look at the environment variables in the path, there will generally be%programfiles%\microsoft SQL Server\110\tools\binn This is the location of SQLLOCALDB storage, if the CMD does not take effect, Edit the button click (Nothing to change), then OK, the final outer layer is OK, let the new path take effect.
Create a DB instance CSQLLOCALDB Create "instance name"-S parameter-s optional, plus after the creation of a direct instance
Delete db instance DSQLLOCALDB Delete "instance name"
Start/Stop instance s/pSqllocaldb start|stop "Instance name" stop defaults to close the instance after the query is completed-I mate stop is immediately stop developing an instance-K to stop an instance if there is no link to the instance
Shared Instance HSqllocaldb share|h ["Owner SID or Account"] "private Name" "Share name" shares the specified dedicated instance with the specified share name. If the user SID or account name is omitted, it defaults to the current user.
Stop sharing USqllocaldb unshare "Share name"
View information ISQLLOCALDB info ["Instance name"] View all, or specify the instance name
Version vSQLLOCALDB version
Tracking TTrace On|off turn on database tracking
2. Manage LOCALDB using SQL Server Management Studio (SSMS)Let's say we create a new instance named test01, and then we see this with info: the instance pipeline name: Np:\\.\pipe\localdb#7a15dcd7\tsql\query Here, copy the NP-beginning content to the server name, Then authentication selects Windows to connect. When you connect, you see the same content as any other database: The rest of the usage is just like standard SQL Express.
SQL Server LocalDB Learning Note 02 Basic management
