I have a sequence of events that need to take place for a workstation.
1) it needs to stop the sql service
2) copy mdf and ldf files over the network to a backup location
3) start the sql service
do I have to schedule 3 separate tasks in task scheduler to complete this?
or in one powershell script can I.
1) stop sxql service
2) wait 30 minutes
3) copy over mdf and ldf files
4) start sql service
or would I have to have 3 separate scripts run each on its own task
task1) stop sql service
task2) copy over folders
task3) start sql service