Skip to content

DeepthiGoguri/CodeMash2026

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages