how to take backup of the DB

[QUIGroup]

All you need to do is Right Click on top of the DB --> go to Tasks --> Backup.
Or if you prefer to use T-SQL, just run this command.

BACKUP DATABASE EmployeeDB TO DISK='C:\MyBackupFolder\EmployeeDB.bak'

DbDefence - transparent database encryption and SQL protection