I want to create and use a bak file of an SQL Server db.
The database is accessible via SSMS (v 17.9.1) and is on the local machine (not MY machine, but a remote server to which I log in directly). I managed to create a bak file using the easy way of right click -> Tasks -> Backup.
The problem is that when I try using that file, I'm getting an error saying I need to use a backup file with a UNC format since the db is on another machine.
1) Why does it say it's on another machine if the SSMS shows on top the same machine name I login to?
2) How can I create the bak file in a UNC format? Since I'm not that familiar with SSMS in general, I'll be glad if you could guide me on where exactly I need to navigate inside to get to wherever I need to.