Required tools

• We are gonnna use:
  • SQL server develeoper edition
  • SQL Server Management Studio
• Download and install SQL Server developer edition: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
• Download and install SSMS: https://aka.ms/ssmsfullsetup (SSMS => SQL Server Management Studio)

Sample databases

• .bak files provided by micrsoft will be used
• use AdventureWorks (because ‘Wide World Importers’ is old)

Download sample database (.bak file)

• AdventureWorks
• Wide World Importers
• IoT Smart Grid

Restoring from backup file

• Put .bak file in .../Backup folder
  • C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER_DEV\MSSQL\Backup
  • MSSQL15.MSSQLSERVER_DEV => different for you depending on your SQL Server name
• Connect SQL Server to SSMS
  • Make sure SQL Server developer edition is running
    • Task bar > Search: “SQL Server”
    • Open: SQL Server Configuration Manager > SQL Server Services > SQL Server (SQLSERVERDEV)
    • if not running: SQL Server (SQLSERVERDEV) > Right click > Start
  • Start SSMS => SSMS should automatically detect the running SQL Server
  • Use windows authentication
• Now restore sample database (i.e. AdventureWorks2017.bak) using SSMS

Restoring sample database for Azure SQL

See: Restoring a sample database for Azure SQL using blob storage and SSMS from a VM