Thank you so much Stefan. That worked. Thanks and regards Praveen Singh
On Thu, Feb 25, 2021, 1:10 PM Stefan Hornburg (Racke) <[email protected]> wrote: > On 2/25/21 8:32 AM, 'Praveen Kumar Singh' via Ansible Project wrote: > > Hello Stefan, > > > > I am trying to create a playbook to perform the three below mentioned > tasks which is to accomplish the database refresh. > > First two tasks (Database backup and Backup copy to destination server) > are running fine 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. > > > > Hello Praveen, > > I would put both servers into "hosts" and add a condition to each task: > > Either > > when: inventory_hostname == 'SQLSERVER' > > or: > > when: inventory_hostname == 'SERVER2' > > Regards > Racke > > > --- > > - hosts: SQLSERVER > > vars: > > DbName_Source: > > ansible_become_user: Ansible > > ansible_become_pass: xyz@123 > > DbName_Destination: > > > > vars_prompt: > > - name: DbName_Source > > private: no > > prompt: Source Database > > default: > > > > - name: DbName_Destination > > private: no > > prompt: destination Database > > default: > > > > > > tasks: > > - name: DB Backup > > win_shell: | > > $Backup = "BACKUP DATABASE {{ DbName_Source }} TO DISK = > 'E:\Backup\{{ DbName_Source }}-Databasebackup.bak'" > > Invoke-SqlCmd -Query $Backup > > > > - name: Sync SQLSERVER to SQLSERVER2 > > become: yes > > become_method: runas > > become_flags: logon_type=new_credentials > logon_flags=netcredentials_only > > win_copy: > > src: E:\BACKUP\ > > dest: \\xx.xxx.xxx.xx\E$\BACKUP\ > > remote_src: yes > > > > - name: DB Restore > > win_shell: | > > $Restore = "RESTORE DATABASE {{ DbName_Destination }} FROM > > DISK = N'E:\BACKUP\{{ DbName_Source > }}-Databasebackup.bak' > > WITH FILE = 1, > > MOVE N'{{ DbName_Source }}' TO > N'D:\SQLDATA\MSSQL15.MSSQLSERVER\MSSQL\DATA\{{ DbName_Destination > > }}.mdf', > > MOVE N'{{ DbName_Source }}_log' TO N'L:\SQLLOG\{{ > DbName_Destination }}_log.ldf', > > NOUNLOAD, REPLACE, STATS = 5" > > Invoke-SqlCmd -Query $Restore > > > > Thanks and Regards, > > Praveen Singh > > > > On Wed, Feb 24, 2021 at 11:23 PM Stefan Hornburg (Racke) < > [email protected] <mailto:[email protected]>> wrote: > > > > On 2/24/21 4:17 PM, 'Praveen Kumar Singh' via Ansible Project wrote: > > > Is there any way to change the target server name in the middle of > the playbook? This is for windows. > > > > > > Thanks and Regards, > > > Praveen Singh > > > > > > > Hello Praveen, > > > > do you mind to explain which use case you have in mind? > > > > Regards > > Racke > > > > > -- > > > You received this message because you are subscribed to the Google > Groups "Ansible Project" group. > > > To unsubscribe from this group and stop receiving emails from it, > send an email to > > > [email protected] <mailto: > ansible-project%[email protected]> > > <mailto:[email protected] <mailto: > ansible-project%[email protected]>>. > > > To view this discussion on the web visit > > > > > > https://groups.google.com/d/msgid/ansible-project/CAJK1W%3Dzg-tBoPhG6dAY889xGPrhfScVu1Q_D_jApPyV64bcJLw%40mail.gmail.com > > < > https://groups.google.com/d/msgid/ansible-project/CAJK1W%3Dzg-tBoPhG6dAY889xGPrhfScVu1Q_D_jApPyV64bcJLw%40mail.gmail.com > > > > > > > < > https://groups.google.com/d/msgid/ansible-project/CAJK1W%3Dzg-tBoPhG6dAY889xGPrhfScVu1Q_D_jApPyV64bcJLw%40mail.gmail.com?utm_medium=email&utm_source=footer > > < > https://groups.google.com/d/msgid/ansible-project/CAJK1W%3Dzg-tBoPhG6dAY889xGPrhfScVu1Q_D_jApPyV64bcJLw%40mail.gmail.com?utm_medium=email&utm_source=footer > >>. > > > > > > -- > > Ecommerce and Linux consulting + Perl and web application > programming. > > Debian and Sympa administration. Provisioning with Ansible. > > > > -- > > You received this message because you are subscribed to the Google > Groups "Ansible Project" group. > > To unsubscribe from this group and stop receiving emails from it, > send an email to > > [email protected] <mailto: > ansible-project%[email protected]>. > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/ansible-project/88f6f91c-c7a5-23a1-73d2-a39dc8614396%40linuxia.de > > < > https://groups.google.com/d/msgid/ansible-project/88f6f91c-c7a5-23a1-73d2-a39dc8614396%40linuxia.de > >. > > > > -- > > You received this message because you are subscribed to the Google > Groups "Ansible Project" group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to > > [email protected] <mailto: > [email protected]>. > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/ansible-project/CAJK1W%3Dw_eRASn-Z-NhbBPHao-Sb4ytoKRz3uG9se%3DAAiVb_%3D9g%40mail.gmail.com > > < > https://groups.google.com/d/msgid/ansible-project/CAJK1W%3Dw_eRASn-Z-NhbBPHao-Sb4ytoKRz3uG9se%3DAAiVb_%3D9g%40mail.gmail.com?utm_medium=email&utm_source=footer > >. > > > -- > Ecommerce and Linux consulting + Perl and web application programming. > Debian and Sympa administration. Provisioning with Ansible. > > -- > You received this message because you are subscribed to the Google Groups > "Ansible Project" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ansible-project/4eb20aa8-ccd2-6ca4-8f18-7ebe6514ea31%40linuxia.de > . > -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAJK1W%3DzqSLFjOUP%2B_j3V2HGUHihn%3DpkhaquHvC1WNQLNoiQb2g%40mail.gmail.com.
