Hi Everyone,
I have 2 servers running SQL Server 2014 which are in different location. Server 1 does not see Server 2 and vice versa. I have a shared drive where both servers can access. On server 1, I have created a backup job and the backup file is saved locally. I need to move the backup to the shared drive. And then, on Server 2, take the backup file and restore it. I need to automate the process.
Any help and solution is greatly appreciated.
Sal
What I have tried:
I have created the backup job and a batch file to move the file to the shared drive. The backup ran successfully but the Move database does not work using SQL job. If I ran the batch file manually, it does move the backup file.