When you edit a .sql file, Interactive SQL automatically creates a backup copy after:

If you are editing a file and Interactive SQL closes unexpectedly, you are prompted to recover the file, the next time you start Interactive SQL.

You can also back up your favorites. See Sharing Favorites.