Please also download these two backup files from the below links-
https://drive.google.com/file/d/1tAFbfGiSzGHpxyrNtTOtGMpAfY8PFSSv/view?usp=sharing https://drive.google.com/file/d/1MzbeM-yx-sW7tbtJHhGO7u0jWVm45o6W/view?usp=sharing
execute this code in ssms tool to restore the databases. Restore this on Microsoft SQL Server 2019 Server. Restore script for adventureworks - Replace the file location depending on where your database backup file is-
USE [master]; GO RESTORE DATABASE [AdventureWorks] FROM DISK = 'C:\MSSQL\Backup\adventureworks.bak' WITH MOVE 'AdventureWorks2016_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\AdventureWorks2016_Data.mdf', MOVE 'AdventureWorks2016_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\AdventureWorks2016_log.ldf'
Restore script for WideWorldImportersDW- Replace the file location depending on where your database backup file is-
USE [master]; GO
RESTORE DATABASE [WideWorldImportersDW] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Backup\WideWorldImportersDW.bak' WITH FILE = 1, -- Usually 1 for a single full backup file MOVE N'WWI_Primary' TO N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\WideWorldImportersDW.mdf', MOVE N'WWI_UserData' TO N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\WideWorldImportersDW.ndf', MOVE N'WWI_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\WideWorldImportersDW_log.ldf', MOVE N'WWIDW_InMemory_Data_1' TO N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\WWIDW_InMemory_Data_1', NOUNLOAD, -- Retains the backup device in the tape drive (general practice, can be omitted for disk) STATS = 5; -- Displays progress messages in 5% increments GO