SQL Server (localdb)\v11.0 explained

by

  1. LocalDB was introduced in SQL Server 2012 CTP3. It’s basically a new version of SQL Express, with same functionality, dedicated to developers. So you don’t need to install any SQL server. If you have installed SQL 2012 or Visual Studio 11 then you already have it, and it runs over .Net 4 or higher. If you are using Visual Studio 11 and have been playing with the new EntityFramework and MVC, you can see it on the default connection string.

  2. MDF is the default extension for SQL Server database files. (Log files are LDF) Also see this question.

  3. You can restore to a specific folder by using RESTORE DATABASE WITH MOVE as documented on MSDN here.

  4. LocalDB is intended for developers, see point 1.

  5. The SQL Server Express blog has an informative post about LocalDB here.

More Related Contents:

  1. LocalDB deployment on client PC
  2. What is the use of GO in SQL Server Management Studio & Transact SQL?
  3. What is the best way to auto-generate INSERT statements for a SQL Server table?
  4. How to see query history in SQL Server Management Studio
  5. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  6. sql server invalid object name – but tables are listed in SSMS tables list
  7. SSMS Results to Grid – CRLF not preserved in copy/paste – any better techniques?
  8. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  9. EF5: Cannot attach the file ‘{0}’ as database ‘{1}’
  10. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  11. Connecting to SQL Server LocalDB using JDBC
  12. Query times out when executed from web, but super-fast when executed from SSMS
  13. How do you specify a different port number in SQL Management Studio?
  14. Unique constraint on multiple columns
  15. Format SQL in SQL Server Management Studio
  16. Import / Export database with SQL Server Server Management Studio
  17. How to prevent SQL Server LocalDB auto shutdown?
  18. Removing the remembered login and password list in SQL Server Management Studio
  19. The request failed or the service did not respond in a timely fashion?
  20. FOR JSON PATH results in SSMS truncated to 2033 characters
  21. SQL Server 2008 can’t login with newly created user
  22. SQL server query to output the data shown below
  23. How to use a variable for the database name in T-SQL?
  24. Create a view with ORDER BY clause
  25. INSERT INTO vs SELECT INTO
  26. SQL Server 2008: how do I grant privileges to a username?
  27. Possible to store value of one select column and use it for the next one?
  28. How can I Insert data into SQL Server using VBNet
  29. Incorrect syntax near ”
  30. Using GROUP BY with FIRST_VALUE and LAST_VALUE

Leave a Comment