Step 2: Open your SQL server Management Studio and Restore. Lightweight (LT) data is a lightweight and pared down version of the OLTP(online transaction processing workloads) sample. Once you have downloaded it, open the 'Downloads' Folders (Where file is downloaded) and copy/paste it in root folder of D: or E: Drive, basically we are doing this, so we don't get any error related to protection rights. It is around 46.7Mb in Size.ĪdventureWorks2022.bak ( AdventureWorksLT2022.bak)ĪdventureWorks2019.bak ( AdventureWorksLT2019.bak)ĪdventureWorks2016_EXT.bak (125MB) This is an extended version of AdventureWorks, designed to showcase SQL Server 2016 features I will be downloading AdventureWorks2016.bak for this tutorial. So, this is our first step to download complete sample database of AdventureWorks, there are many SQL server versions of the sample database. Basically, we will be restoring the AdventureWorks sample database in our local SQL server. In this article, I have explained from where you can download AdventureWorks sample database and congifure it to use in local SQL server database.
