I have a problem with log shipping in SQL Server 2012.
I have two servers for log shipping, let's say server A and server B.
For the first experiment, when I use a shared folder from my computer based on Windows 10, it works great.
But when I try to use a shared folder from my file server such as synologi or infortrend, it failed, even after I added permissions for SQL Server Agent, my administrator on each server, my user on each server, even if I added full control permission for everyone.
Do you have any advice for my problem? Or must SQL Server 2012 log shipping use a file server which is based on a Windows OS?
When I look in the job history, I see:
Error, Can't open backup device
I assume that this backup job from log shipping can't be done because the device (file server) cannot be accessed by SQL Server.
I am very sure that my servers, and my file server, use the same domain and the same segment, that's why I doubt that log shipping from SQL Server 2012 really works with a file server.
If I manual backup using the GUI, it won't show us the directory mapped in My Computer. But if I use a backup script, it would fail because there is no file backup in my file server.
BACKUP DATABASE command to the share, I get the following error message:
Msg 3201, Level 16, State 1, Line 1 Cannot open backup device '\\[fileserver IP]\coba\TESTLAGICOBA.bak'. Operating system error 86(The specified network password is not correct.). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally.