Backing up to a Share out side of the network

KayE

Hi Is it possible to backup using SQL Backup to a share that is out side the network?

What I'm trying to achieve is to send non critical backup to a NAS drive which is outside of our network. Currently this is possible with LiteSpeed as its happy to accept username/password for the share and execute the backups/restores.

I haven't found an option on SQL Backups.

Thanks

Dan B

Hi Kay,

This can be achieved by following the instructions below, this is taken from our documentation page here: https://documentation.red-gate.com/sbu9/permissions

Working with servers on different Windows domains
If you are working with servers which do not participate in the same Windows domain, you can still use SQL Backup Pro to work with them as usual by setting up "matching accounts". This will be necessary if you want to copy backups to a locked down network share on a different Windows domain, or set up log shipping between servers on different domains.

Create accounts on each machine with identical user names and passwords.
Set the SQL Backup Agent service to log in to the SQL Server using the account created in step 1, using the sqbsetlogin extended stored procedure. For more information, see Changing the authentication mode above.
When log shipping, the SQL Backup Agent on both SQL Servers must log in using the matched account.
Give the account on the other domain access permissions to the relevant locations.

KayE

Hi Dan, thanks for the response.

All our SQL Agent services run under a domain service account and its not possible for us change it to be local account to match the account with the NAS drive share. Is there any other work around?

Thanks,
Kay

Dan B

Hi Kay,

Unfortunately within SQL Backup we can't do anything here unless there are trusts setup with the domains.

There is a Copy Tool available here ftp://support.red-gate.com/patches/sql_backup/Copy Tools/CopyTool.zip which is a stand-alone unsupported tool that maybe configured to copy the backup files from the SQL server to the NAS outside of SQL Backup.

Please let me know if you need any assistance setting the tool up.