Does anybody have a method to query or wake up the network drive before the Syncback job runs?

You can write a batch/script file that uses the 'Wake ON LAN' event to wake the remote computer and call this in the Program-Before section of the profile run. You can refer to this forum post for more details: