I have a server where all my sql server backups are currently being saved to the G: drive.
Now there is no enough disk space on drive G: to keep backups for the last 5 days. I have asked to add another 100 GB to this G: drive but that was not possible, so they gave me another drive instead, the I: drive with extra disk space, as you can see on the picture below.
Now I need to replace all the references to the G: drive in the sql server jobs below to point to the new I: drive.
Suppose I have 3 servers in the same situation, how can I achieve this by T-SQL?