Set TraceLog attribute of Google Drive destination to TRUE value

Set TraceLog attribute of Google Drive destination to TRUE valueWhen 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 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.

Leave a Reply

Your email address will not be published. Required fields are marked *