I enter an SQL query text with line breaks.
Then I run the job Backup Settings.
In the SQL query text, all line breaks are replaced by some other character, displayed as a box.

Did you try to use in your query?

Regards
Erik

---

I just entered text like:
SELECT *
FROM SomeTable
WHERE SomeField = 1

After the backup I get:
SELECT * +FROM SomeTable +WHERE SomeField = 1

Instead of the + sign read 'box' character.

But did you paste the text from other program? Try delete the text and write manually.

---

I thought you where talking about the output of the query... 😣


I made a new job with one sql task having the code



I ran the job, everything works fine. After I made a backup (with the backup job) I closed and started the client again.
I still have the same code in my SQL text query, no plus signs.

Can you reproduce the problem?

Are you alo using the latest version (4.9.21)?

---

I can't reproduce it now. Funny.
I often build a query in SQL management studio and paste it in Visual Cron.
I then (in VisualCron) add some line breaks to make it more readable. Maybe that's what makes the difference?