SQL Server DB Restore

Archives Ansible Project
1

Hello Everyone,

I am trying to create a playbook to perform the three below mentioned tasks. I am able to accomplish the first 2 tasks but for the third one which is to restore the Database I need to change the host server as windows server 2. So I am not sure how I can achieve it. The playbook I am using is below:

  1. Taking backup on remote windows server 1.
  2. Copying that backup to another remote windows server 2.
  3. Restoring that backup to remote windows server 2.
2

can someone please help me on this

thanks and regards,
Praveen Singh

3

Is there any solution for this to change the target server name in the middle of the playbook? This is for windows.

Thanks and Regards,
Praveen Singh