How to Import Sample Database Into SQL Server Database| Restoring the AdventureWorks Database file.
#SQLServerManagementStudio #SQLServer2022 #starsintech
Hello Friends,
In this video, I explain about the How to Import Sample Database into SQL Servers 2022 Using SQL Server Management Studio.
If you Like the Video Please Share and Subscribe to the My Channel.
/ @starsinfotchclasses
Playlists:
• MS SQL Servers Tutorials.
Thank You.
Stars InfoTech
Chapters
00:00 Introduction to Topic.
00:44 Downloading the Backup file.
01:55 Changes the .Bak File to C:\ Drive.
02:42 Restore the Database using SSMS.
03:50 Check the Restore Database Details.
04:27 End
Steps for Import / Restore Database Backup File into SQL Server 2020
Step 1: Go to the link: https://learn.microsoft.com/en-us/sql.... In the Additional OLTP backups and samples section, download the file: AdventureWorks2022.bak.
Step 2: From the Downloads folder, copy the downloaded .bak file of AdventureWorks2019 to the path: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Backup.
Step 3: Open Microsoft Server SQL Management Studio, in the object explorer, Databases, right click on the Databases folder and choose the option Restore Database.
Step 4: Inside the Source section, switch to the Device option from Database.
Step 5: Browse the AdventureWorks.bak file path and add it.
Step 6: Click OK and proceed.
Step 7: Now AdventureWorks has been restored, we can check this by running a query through one of the tables in the tables folder of AdventureWorks.
#ssms #sqlserver2022 #sqlserver #sqlforbeginners #sqlinterviewquestions #sqltraining #datascience #viralvideo #jobinterview #education
/ @starsinfotchclasses
https://learn.microsoft.com/en-us/sql...