Am I able to improve this code?

[BrailleSchool]

I don't really see how this is not plain Englishoes the log contain work you don't want to lose or doesn't it? If it does then change your BACKUP statement as the error message tells you to. If it doesn't then you can just overwrite it, so change your RESTORE statement as the error message tells you to. That's actually one of the clearest error messages I've seen.

Have you ever restored a backup in SQL Serever Management Studio? Have you selected the Options tab and checked the Overwrite box? That is the visual equivalent of use WITH REPLACE.

I have been attempting to update the SQL and regardless of what I try, I get errors. It's not liking it. I'll keep at it and see what I can do.