Search code examples
sql-serverdatabaseumbracolocaldb

Can't find umbraco data storage

I have installed Umbraco via WebMatrix, and entered "server=(localdb)\v11.0;integrated security=true" as a connection string. The site works fine, but I can't find the database that Umbraco have created. When I open the (localdb)\v11.0, it's not there.

I have tried searching whole system with *.mdf. but no luck. Where can the data be?

I am using umbraco 4.8.0

Solution

  • I have found it. With no Database defined, SQL server uses the first or the default database in the list, which appears to master database. SSMS and such, don't display tables of system objects, so I found the tables by querying the database.