STEP 1: Right click on database and then select Tasks then Back Up.

STEP 2: Click on Add button.

STEP 3: By clicking three dots (...) select you file location where you want to save the backup file.

STEP 4: Select location and type file name. Make sure to give file name with extension .bak.

STEP 5: Click OK.

STEP 6: Click OK.

STEP 7: Backup of database completed successfully.

SQL Script
BACKUP DATABASE [Hospital]
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Backup\Hospital_LogBackup_2023-05-24_11-48-21.bak'
WITH NOFORMAT, NOINIT, NAME = N'Hospital-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO