I couldnt help but notice you are using an administrative share:

\\hostname\d$\SQLBACKUP\database

Accessing D$ on the host can only be done by accounts that are a member of the local administrators group on the host server.

It is better suited to access the other host via a regular share such as

\\hostname\SQLBAckup\database