How can we help you today? How can we help you today?

SQL Backup accessing file on different domain.

I am trying to set up jobs to restore logs from a nas server on a different domain. I have a plan B to step a batch job that will map a drive (logging on with different credentials), but I was hoping that there was a way within SQL Backup to do this.

Thanks - Jeremy.
cjeremy74
0

Comments

2 comments

Sort by
  • Eddie D
    Thank you for your post into the forum.

    SQL Backup does not support mapped drives.

    If you use to use SQL Backup to restore files across the network, you must set up a Network Shared folder on the nas server and place the file or files you wish to restore into the network share.

    The account given to the SQL Backup Agent on the SQL server you are restoring too, requires permissions to the network share to read the log file backups.

    Please take a look at this document:
    http://www.red-gate.com/products/SQL_Ba ... kShare.pdf

    Although the document is for backing up to a network share, the security requirements are exactly the same for restoring from a network share.

    Hope this helps.

    Many Thanks
    Eddie

    Eddie Davis
    Product Support Engineer
    Red Gate Software Ltd
    E-Mail: support@red-gate.com
    Eddie D
    0
  • cjeremy74
    Thanks for the link... I will go through this in detail, but it looks like I will have to go to plan c which will be using a batch script to go out to the other domain (it's a colocated domain that crosses the firewall) and copy the files over. I think that this will work reasonably well.

    Thanks - Jeremy.
    cjeremy74
    0

Add comment

Please sign in to leave a comment.