Set TraceLog attribute of Google Drive destination to TRUE value
If you encounter an error that 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 the 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 a detailed log of backup uploading to Google Drive destination.
If you are still having issues with this please leave a comment on this article.