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" />
- 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.