3 ms·
> Backup or restore while a transaction is active I wonder does that apply to Windows? Well-designed Windows backup software uses shadow copy NTFS feature. Sh
by Const-me 7y ago
> Backup or restore while a transaction is active
I wonder does that apply to Windows?
Well-designed Windows backup software uses shadow copy NTFS feature. Shadow copy creates a snapshot of the complete volume when backup starts. All writes happening after that won’t be included in the shadow copy, so the backup software should never read some old and some new content.
Does it mean when using VSS on Windows, SQLite databases will be backed up just fine? Or am I missing something?
- DenisM 7y agoYou're probably right. Taking a VSS snapshot is identical to pulling the power plug and imaging the drive. If SQLite hand handle the latter it should be able to handle the former. Another thing that should work well is an AWS EC2 EBS snapshot as Amazon promises a consistent point in time copy.