Hi Lls71 - I would suggest opening a support ticket to get to the bottom of this.
There is an issue with the Main.DB.Backup.CatTools.txt script in version 3.4.0 which reports the backup failed when it has in fact worked (my bad). I attach an updated version which resolves this issue. Backup your existing script first then copy the one attached into your CatTools scripts folder.
With respect to the database size I believe this is because as part of the database backup activity we perform a squeeze so the backed up file should be considerably smaller. If you took a copy of the backup database and then in CatTools File|Database|Open/New switch to this you will be able to check that it's got everything. (Don't forget to switch back after the test.)
I'd be interested to know how you get on.
Main.DB.Backup.CatTools.txt 4.2 KB
Thanks for the script, now it works fine!