How to take a remote SQL server database backup to local machine? I've to take a SQL database backup from remote machine to local Linux machine and through command line. Hence executed following command -
sqlcmd -S xxx.xxx.xxx.xxx -U &lt;username&gt; -P &lt;password&gt; -Q &quot;BACKUP DATABASE [TestUser] TO DISK='TestUser.bak';&quot;

But this takes backup on machine where database server is installed. Is there any way I can get backup on machine where it is executed?
**NOTE: ** I can see many questions which asks same but are old ones and answer - either this is not supported or use of third party tools. Hence asking question again, in case has solution with latest stuff.
try to use an unc path in this way:
sqlcmd -S xxx.xxx.xxx.xxx -U &lt;username&gt; -P &lt;password&gt; -Q &quot;BACKUP DATABASE [TestUser] TO DISK='\\server\shared_folder\TestUser.bak';&quot;

You have to give SQL Server Service User the right to write to the remote path
\\server\shared_folder\
To do this you have to configure a local samba share connected to the source domain (as a domain member)