Error in Remote .sql backup

How it works
1

Hello. Can you explain what this error means.

The column prefix ‘cstr’ does not match with a table name or alias name used in the query.

2

Hi Chuck,

To investigate this case we need more information. Could you please tell us more details about this issue? When exactly do you get this error message? Also, could you please enable “Advanced Log”, reproduce the issue and send logs to our development team? Please find more details on how to do it at https://sqlbackupandftp.com/blog/how-to-send-log-to-developers

Sorry for the inconvenience.

3

Thank you for the reply. I have sent the log file per your instructions.

4

Hi Chuck,

Thanks for the logs, please give us some time to investigate this issue.

Sorry for the inconvenience.

5

Find anything that might be causing this issue? I would really like to make sure this is working before buying. Thanks

6

Hi Chuck,

Could you please install the new version and check if it resolves the issue. Please download it by the following link https://www.dropbox.com/s/q59zq1sqpvq76y2/SQLBackupAndFTPSetup.exe?dl=0

Sorry for the inconvenience.

7

I’m using 11.6.1 Is there a newer version. I downloaded the one you just gave me a link to, but still get error : “The column prefix ‘cstr’ does not match with a table name or alias name used in the query.”

8

Hi Chuck,

Thanks for the feedback.

Could you please clarify are you able to perform a remote backup via SQL Server Management Studio?

SQLBackupAndFTP.png580×516 19.7 KB

Sorry for the inconvenience.

9

I don’t have SQL Server Management Studio or I would just do my .sql file generation from there.

10

I installed SQL Server Management Studio 2008 RS 10.50.2500.0 and it worked.

11

Hi Chuck,

Thank you for the details.

Please give us some time to investigate this case.

Sorry for the inconvenience.

12

Hi Chuck,

Could you please download, install, and check if the following version https://www.dropbox.com/s/j0zrbkmy1s4999m/SQLBackupAndFTPSetup.exe?dl=0 resolves the issue?

We have added some changes to that version so the backup into script will take more time.

If you still have this issue, please save the NLog.config file into the application folder C:\Program Files (x86)\SQLBackupAndFTP, restart “SQLBackupAndFTP (SQL Server backup)” Windows service, run the application and reproduce the issue. After the issue is reproduced please send us all log files from C:\Log\SBF folder.

To download Nlog.config file please follow this link https://www.dropbox.com/s/qsxhu9gz1k0rqf5/NLog.config?dl=01

To make your logs private please send them to support@sqlbackupandftp.com

Sorry for the inconvenience.