For example, the default location for a default instance of SQL Server 2019 (15.x) is:Ĭ:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Backup. This varies depending on your installation location, instance name and version of SQL Server. bak file to your SQL Server backup location. bak file from one of links provided in the download backup files section. To restore your database in SSMS, follow these steps:ĭownload the appropriate. If you're not familiar using SQL Server Management Studio (SSMS), you can see connect & query to get started. You can do so using the RESTORE (Transact-SQL) command, or using the graphical interface (GUI) in SQL Server Management Studio (SSMS) or Azure Data Studio. bak file to restore your sample database to your SQL Server instance.
OLTPĪdditional files can be found directly on GitHub: If you're not sure what you need, start with the OLTP version that matches your SQL Server version.
OLTP data is for most typical online transaction processing workloads.Use these links to download the appropriate sample database for your scenario. SQL Server Management Studio (SSMS) or Azure Data Studio.This article provides direct links to download AdventureWorks sample databases, and instructions for restoring them to SQL Server, Azure SQL Database, and Azure SQL Managed Instance.įor more information about samples, see the Samples GitHub repository. Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)