So I did some more searching and found out how to get QuickBooks automatic backup working... sorry it's long winded but the link below got my backups working. My setup is QuickBooks Enterprise 19 on Windows Server 2019:
Basically, when you set up automatic backups in QuickBooks it adds a task to the Windows Task Scheduler but fails to set them up correctly.
After setting up automatic backups in QuickBooks for each company file, I opened the Windows Tasks and found the tasks were configured for "Windows Server 2003, Windows XP, or Windows 2000"... but we're running Windows Server 2019. Here's the task that QuickBooks set up:
Make sure you're logged in as the Windows administrator account, then change the task configuration to the correct version, in my case "Windows Server 2019". I set the automatic backup to a few minutes out, it now creates a .tmp file - at least it creates a file now, shows I'm on the right track.
I reopened the Windows task and checked the "Do not store password" box so it only had access to local resources. I had to enter the Windows admin password when I set up the automatic tasks, but checking the box here allowed my backups start saving correctly. Here's my final settings:
On a side note... QuickBooks restricts the backup schedule to 10 minute increments, but you can go to the Triggers tab in the task and adjust it to whatever time you want.
One variable remaining, the company file I was testing was open when the automatic backup schedule ran... the other company files are closed so we'll see if those scheduled backups run correctly when the file is closed.
