Copy the script below and modify the path to the MDF file as according to your environment and click Execute. Rentals Details: Microsoft has a nice sample database called AdventureWorks available free for you to use.Connect to the SQL Server and click on New Query.Open SQL Server Management Studio as Administrator.For more information, see View or Change the Default Locations for Data and Log Files (SQL Server Management Studio). Note: The default location for storing data and log files of SQL Server 2012 Express (圆4) is C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA. In this example, I keep it in C:\databases. Place the downloaded file (the MDF file) to your database folder.Rentals Details: Additional files can be found directly on GitHub: SQL Server 2014 - 2019 SQL Server 2012 SQL Server 20R2 Restore to SQL Server. Download “Adventure Works” sample database from CodePlex at Adventure Works for SQL Server 2012 by select AdventureWorks2012 Data File. AdventureWorks sample databases - SQL Server Microsoft Docs.Step-by-step to install sample database Adventure Works On this post, you will see step-by-step guide how to attach/install sample database Adventure Works on SQL Server 2012 Express using SQL Management Studio.
