Writing to disk on mac/linux using SQL Server Command Line tools

Asked Feb 21 '21 at 00:34

Active Feb 21 '21 at 07:25

Viewed 187 times

My objective is to backup a remote SQL Server database using SQL Server command line tools for Mac (or Linux). After installing the sqlcmd utility, I am able to connect to the database but am not sure how to handle the TO DISK command, whose default is to assume a Windows operating system.

sqlcmd -S myserver.com -U AIS -Q "BACKUP DATABASE mydb TO DISK = N'/mybackups/mydb.bak' WITH NOFORMAT, NOINIT, NAME = 'mydb', SKIP, NOREWIND, NOUNLOAD, STATS = 10"

This command returns the error:

Cannot open backup device 'D:\BACKUP\mybackups\mydb.bak'. Operating system error 3 (The system cannot find the path specified).

I have tried changing access permissions of the folder mybackups using chmod 777 mybackups but the same error is still thrown. Any idea about how to solve this?

edited Feb 21 '21 at 07:25

marc_s

732,580
175
1,330
1,459

asked Feb 21 '21 at 00:34

iskandarblue

7,208
15
60
130

1

You are aware that `BACKUP TO DISK` refers to the SQL Server's local disk, not yours (the client)? – Charlieface Feb 21 '21 at 01:51
I was not aware of that; how does one move a backup from a SQL Server local disk then? – iskandarblue Feb 21 '21 at 02:06
By copying the files. – Charlieface Feb 21 '21 at 02:07
Does this answer your question? [How can I backup a remote SQL Server database to a local drive?](https://stackoverflow.com/questions/3942207/how-can-i-backup-a-remote-sql-server-database-to-a-local-drive) – Charlieface Feb 21 '21 at 02:07

Writing to disk on mac/linux using SQL Server Command Line tools

0 Answers0