Set TraceLog attribute of Google Drive destination to TRUE value

Set TraceLog attribute of Google Drive destination to TRUE value
When using SQLBackupAndFTP with Google Drive as your cloud storage for your backup files, you might encounter an error that reports “Invalid credentials”.
Read the below article in order to find out what to do in order to quickly solve this.
 

Set TraceLog attribute of Google Drive destination to TRUE value

 If you encounter an error which says your credentials are invalid when you’re trying to upload your backup file to Google Drive using SQLBackupAndFTP, you will find the solution below:

    • Start by opening the .jobx file with Notepad (in the SQLBackupAndFTP install folder) which corresponds to the job you’re running and change TraceLog attribute of Google Drive destination to “true” value.

<Destination pranas:Type="GoogleDrive" Path="sql/backup" TraceLog="true" Id="0d997819-5558-492c-9bf6-af0be52ce77f">
<KeepInfo KeepMonths="6" KeepDays="0" />
</Destination>
    • After that open the .jobx file with SQLBackupAndFTP and run the job. As a result you should see detailed log of backup uploading to Google Drive destination.

If you are still having issues with this please leave a comment to this article.

[Total: 1    Average: 5/5]