Find the database you want to create a backup in Object Explorer.
Right click on the database you want to create a backup, select Task, then select Backup
In this example, I am going to created a full backup of the Core database, and the Backup type is a Copy-only backup.
Select your backup’s Media Options
Select your Back Up Options
Click OK after you have chosen your Back Up Options
After the back up ran, you are done backing up your database
Now, navigate to your back up location to see the database backup file
I hope this example is helpful to you, please leave a comment to let me know. Also subscribe to my blog for more MS SQL examples. I tried my best to create and share this example to the readers. If I made mistakes, or if you have ideas for improvements, please follow up to let me know. Thanks.