Hi Simon, Thanks for getting back to me, that sounds like a simple enough plan, I'll be sure to implement that shortly.
Rob -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: 13 November 2009 17:52 To: General Discussion of SQLite Database Subject: Re: [sqlite] Maintenance Tasks On 13 Nov 2009, at 4:03pm, Robert Rawlins - Think Blue wrote: > What tasks would you recommend running on a SQLite database and on what sort > of regularity? I know that's a bit of a 'how longs a piece of string' type > question but I'm just trying to understand if a SQLite database requires the > same sort of attention as others or whether it's simple and robust nature > means it can be left alone. Keep cumulative backups of your database files the same as you'd do for any files. Do a PRAGMA integrity_check every few months. That's it. For more details see <http://www.sqlite.org/pragma.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users