fix(state): make SQLite sidecar archives retriable (opens in new tab)

Archive the canonical legacy database before SQLite sidecars, then detect and finish pending sidecar cleanup on retry without reopening the migrated database.