I have several Win2k8 Win2k12 servers running SQL Anywhere 12.0.1. I'm running the dbbackup utility on my servers to generate full backups to a share on a FreeNAS server every night.
About once a week, one of servers doesn't back up. dbbackup runs, but within 15 minutes or so it completes without generating emr.db or emr.log files, and doesn't truncate the log file.
The servers run this command, where U: is a drive mapped to a CIFS share on the FreeNAS server:
Here is an example of what is logged, where 2/18 had a good backup and 2/19 did not:
My database file sizes range between 60 GB and 500 GB. The intermittent failed backups are happening both on brand new servers as well as on older servers. The FreeNAS server isn't under any stress when this happens. It also seems to happen whether I'm backing up to Windows server shares or FreeNAS CIFS shares.
If I want to generate full backups every night to a FreeNAS server, is running the dbbackup utility on the server the best way to do this?
asked 19 Mar '15, 14:01