A script combining all your commands can be created as a batch file. Below is a step-by-step explanation and the actual batch script code:
ping 8.8.8.8
md d:\databackup\tallydatabackup%date%
Ping 10.10.10.74
xcopy "d:\Tally Prime\Data\*" "d:\databackup\tallydatabackup%date%" /e/v/y/i/s
ping 10.10.10.6
