Online backup
SQLite can back up database files while the app is running. This functionality is available in Microsoft.Data.Sqlite as the BackupDatabase method on SqliteConnection
.
// Create a full backup of the database
var backup = new SqliteConnection("Data Source=BackupSample.db");
connection.BackupDatabase(backup);
Currently, BackupDatabase
will back up the database as quickly as possible and blocks other connections from writing to the database. Issue #13834 would provide an alternative API to back up the database in the background and allow other connections to interrupt the backup and write to the database. If you're interested, provide feedback on the issue.
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for