Connecting Localdb using Sql Server Management Studio Express

1. (localdb)\V11.0 as the server name
2. Note that the instance name V11.0 is case sensitive

My Thanks to (mssqltips.com) for the below

You can interact with SqlLocalDb using the command line. The following will tell you the version of SqlLocalDb:

C:\> SqlLocalDb info

Result:

v11.0

If you want to create an instance:

C:\> SqlLocalDb create "MyInstance"

Result:

LocalDB instance "MyInstance" created with version 11.0.

To  Start the instance:

C:\> SqlLocalDb start "MyInstance"

Result:

LocalDB instance "MyInstance" started.

You can also create an instance and start it in one command using the -s argument:

C:\> SqlLocalDb create "MyInstance" -s

To stop and delete an instance, you can issue two commands:

C:\> SqlLocalDb stop   "MyInstance"
C:\> SqlLocalDb delete "MyInstance"

If you try to just delete the instance without first stopping it, you will get this error:

Delete of LocalDB instance "MyInstance" failed because of the following error:
Requested operation on LocalDB instance cannot be performed because specified instance is currently in use. 
Stop the instance and try again.

To check on the status and other details about an instance, you can run:

C:\> SqlLocalDb info "MyInstance"

Result:

Name:                MyInstance
Version:             11.0.2100.60
Shared name:
Owner:               METEORA\AaronBertrand
Auto-create:         No
State:               Running
Last start time:     4/29/2012 6:17:24 PM
Instance pipe name:  np:\\.\pipe\LOCALDB#ABB78D50\tsql\query

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s