Quote:
Originally Posted by HarryT
The program you're using now is behaving in an unsafe manner; it's evidently simply getting a read lock, and not an exclusive lock, on the files it's trying to copy, and when backing up a SQL database such as the one that Calibre uses this is dangerous, because you could well be backing up the file with potentially uncommitted data. This is the same issue that causes people to end up with a corrupted Calibre database if they put Calibre on a network drive.
SyncToy is behaving absolutely correctly in telling you "I can't back up this file - some other application has opened it.". You really should heed its warnings, not regard them as a problem. In all honesty, I would not trust whatever backup tool you're now using if it's behaving in the manner that you describe. Your backed-up data may very well be corrupt.
Trust me - I do this stuff for a living.
|
I also "do this stuff for a living", and in the real world, most databases are NOT shut down every night so that a backup can be done. Most *modern* backup programs can and do handle database backups without completely shutting down the program and without corruption. I maintain several MS SQL and MySQL databases that are backed up every night, with test restores done at least monthly, and I can tell you that I've never had a backup corrupted because a database was open while it was being backed up.
Shari