Hi all,

I'd like to run an sql query to one of my database but I don't really know how to configure it on visualcron.

The query permit to compress the log file 'MSTR_MD_901_Mobile' database.

BACKUP LOG MSTR_MD_901_Mobile WITH TRUNCATE_ONLY
DBCC Shrinkfile (MSTR_MD_901_Mobile_log, 200)


When running it with Visualcron, it's say's that it can't find out 'MSTR_MD_901_Mobile'in sysfiles. I don't know what i have to change to solve this issue.

Please help

The query itself is very specific to your database and not VisualCron specific. The question is if you are able to connect to your SQL server using the SQL explorer?

---

When running this query in Sql Studio Management, it works fine but not when I run it from VisualCron