Redgate 10 to Synology

Rigerco · October 15, 2019 5:08PM

I just moved a database from server 2008, sql 2008 and redgate v6 to server 2016, sql 2014 and redgate 10. On the old server I could have a scheduled backup write to a Synology external drive that shows up as the "r" drive on the server. The SQL Backup agent is run using the admin account and that account has full permissions for the destination folder. I can see the folder via the gui. When I try the local backup then copy to network folder option the test comes back as "folder does not exist" even though it's the same folder the older version of the software wrote to for years.

What am I missing to get this set up?

squigley · October 16, 2019 10:06PM

Good Afternoon!
Can you try running the query mentioned in the below article on the SSMS with the SQL Backup Agent installed and let me know what result you get?

https://productsupport.red-gate.com/hc/en-us/articles/360010807694

Rigerco · October 17, 2019 1:16PM

I figured it out. I needed to type the full name of the device in the path instead of by the local drive letter ie: not r:\\mystuff\ but instead \\synology\mystuff\

squigley · October 21, 2019 3:51PM

Glad to hear you were able to figure it out!

Redgate 10 to Synology

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk