How to restore database in SQL server 2022?

How to Restore database on SQL Server from Backup
There are 2 ways to restore database
Option 1
Restore database using SSMS

Option 2
We can restore database using T-SQL

Sample Script :
with stats = 10

Point in time Restore :
Sometime we need to restore database with FULL,DIFFRENTIAL and T log backup
For this we need to perform 3 steps
Step 1 : Restore full backup
Step 2 : Restore DIFFRENTIAL backup
Step3 : Restore T log backup

Sample Script :
--Step 1 : Restore full backup. we need to restore database with NORECOVERY to apply more backups
Restore database [WideWorldImportersDW] from disk = 'C:\Omkar\backups\backup\Backup\WideWorldImportersDW_FULL.bak'
with norecovery,stats =10

--Step 2 : Restore DIFFRENTIAL backup. We need to use no recovery here as well to apply log backup.
Restore database [WideWorldImportersDW] from disk = 'C:\Omkar\backups\backup\Backup\WideWorldImportersDW_DIFF.bak'
with norecovery,stats =10

--Step3 : Restore T log backup
Restore log [WideWorldImportersDW] from disk = 'C:\Omkar\backups\backup\Backup\WideWorldImportersDW_TLOG.trn'
with norecovery,stats =10

Restore database [WideWorldImportersDW] with recovery

.
.
.
#sql
#sqldba
#sqlserver
#powershell
#dba
#script
#databaseadministrator
#microsoft
#microsoftazure