0

I have a SQL Server that is running under Windows. And I have a Linux client. AFAIK SQLCMD requires "local" (server-related) path to backup files. So the question is - how to specify windows paths (e:\backups\db_name\etc) under Linux shell or script? Do I need to dublicate backslashes? Or can I use forward slashes?

asked Feb 18, 2022 at 13:58
1
  • 4
    Just use normal Windows file names. The batch is sent directly to the server anyway. You cannot access your Linux client anyway, the path is local to the server Commented Feb 18, 2022 at 14:31

1 Answer 1

0

If you are in an interactive sqlcmd session, no need to escape the backslashes. However, if you use the -Q parameter to execute your backup or restore command, you'll have to double the backslashes, as the string will first be interpreted by the shell before sending it to sqlcmd.

answered Feb 18, 2022 at 17:41

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.