ExpertConnect - Mentoring & Discussions

You can join mentoring & discussions for Free Ask Question, Give Answer, Discuss IT Problems, Learn, and Grow

2017-10-20 14:12:50 4

Transact SQL

Topic menu

2018-09-25 15:01:22 1
Profile picture of Rob Moorhead
Rob Moorhead
Public
Posted: Sep 25, 2018

Are there any instructions for installing the AdventureWorksLT database on a physical computer with SQL Express installed?

Comment (1) ·  Like
Profile picture of Rob Moorhead

Rob Moorhead Sep 25, 2018

It turns out this was fairly simple:

Navigate to https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Download the SQL Server 2017 Express
Install SQL Server
At the end of the installation, click on the Install SSMS button
When that is done, close both windows.
Restart computer
Navigate to https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks
Download AdventureWorksLT.bak and save in C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\Backup
Launch SQL Server Management Studio (SSMS)
Right-Click the Databases node
Choose Restore Database
Under Source choose Device and click the browse button at the right
Click the Add button
Navigate to the BAK file you downloaded (should be the path noted above)
Click OK
Click OK
Click OK on restored successfully message
Expand the Databases node and you should see AdventureWorksLT in the list of databases.

Like (1)

Write a new comment...
Ready to post? select an option: