I did something dumb that deleted a bunch of data from my database (not being used yet, fortunately) and wasn't aware of it for a number of days. It occurred to me that if I was doing a daily backup overwriting the earlier one, I wouldn't have a way back. If I wanted to automate, say, a daily backup that keeps a weeks worth of backups, how might I do this? This is just a simple local database, no server involved.
The "save a copy" script step doesn't have a provision to, say, append a date or time to the file name. Is there another way to do this?