To Manually Back Up an SQL Server Database:

1. Open SSMS and navigate to your server in Object Explorer.
2. Right-click your desired database, then select Tasks > Backup.
3. In the Backup window, specify the Backup Type (e.g., Full, Differential, Log).
4. Choose what to back up and configure any other relevant data.
5. Under the “Destination” section, select Disk and click Add to specify the backup file path.
6. Finally, click OK to initiate the database backup.