{"id":992,"date":"2024-11-28T20:09:37","date_gmt":"2024-11-28T20:09:37","guid":{"rendered":"https:\/\/elusivedata.io\/?p=992"},"modified":"2025-07-18T18:04:34","modified_gmt":"2025-07-18T18:04:34","slug":"recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain","status":"publish","type":"post","link":"https:\/\/elusivedata.io\/nb\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/","title":{"rendered":"Gjenopprette slettede data fra SQLite: Navigere i freeblock-kjeden"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"992\" class=\"elementor elementor-992\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0ea615b e-flex e-con-boxed e-con e-parent\" data-id=\"0ea615b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-00b332e elementor-widget elementor-widget-heading\" data-id=\"00b332e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Innledning<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2321894 e-flex e-con-boxed e-con e-parent\" data-id=\"2321894\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f24c4cb elementor-widget elementor-widget-text-editor\" data-id=\"f24c4cb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>SQLite-databaser er skattekister med digitale bevis som finnes i mange apper, fra chat-meldinger til transaksjonslogger. Men hva skjer n\u00e5r poster slettes? G\u00e5 inn i <em>Freeblocks<\/em>-skjulte deler av ubrukt plass p\u00e5 databasesider som inneholder rester av slettede data. Disse freeblockene er en gullgruve for kriminalteknikere, og gj\u00f8r det mulig \u00e5 gjenopprette kritiske poster og avdekke skjulte bevis.<\/p><p>Denne bloggen avmystifiserer SQLite-freeblocks og g\u00e5r gjennom hvordan de fungerer, hvordan du finner dem med verkt\u00f8y som hex-editorer, og hvordan du gjenoppretter slettede poster. Enten du er etterforsker eller en entusiast innen digital kriminalteknikk, vil denne guiden utstyre deg med viktige teknikker for \u00e5 hente ut skjulte data.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1debb27 e-flex e-con-boxed e-con e-parent\" data-id=\"1debb27\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0ef67f9 elementor-widget elementor-widget-heading\" data-id=\"0ef67f9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Hva er Freeblocks i SQLite?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a8b4a3e e-flex e-con-boxed e-con e-parent\" data-id=\"a8b4a3e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ffd3644 elementor-widget elementor-widget-text-editor\" data-id=\"ffd3644\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Freeblocks er deler av ubrukt plass p\u00e5 en SQLite-databaseside. N\u00e5r en post slettes, overskrives ikke den tilsvarende plassen umiddelbart med mindre en sikker slettingsmekanisme er aktivert. I stedet blir den merket som en <strong>freeblock<\/strong>, tilgjengelig for fremtidige skriverier.<\/p>\n<p>I denne prosessen<\/p>\n<ul>\n<li>Pekeren til den slettede posten fjernes.<\/li>\n<li>Sidetoppteksten oppdateres for \u00e5 gjenspeile fjerningen.<\/li>\n<li>Hvis det er aktuelt, justeres forskyvningen som peker mot den f\u00f8rste friblokken.<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>Disse freeblockene inneholder ofte rester av de opprinnelige dataene, noe som gj\u00f8r dem til et kritisk fokus for rettsmedisinske etterforskere som \u00f8nsker \u00e5 gjenopprette slettede oppf\u00f8ringer.<\/p>\n<h4>Eksempel:<\/h4>\n<p>I skjermbildet nedenfor unders\u00f8ker vi en SQLite-database ved hjelp av DB Browser. Tabellen \"messages\" viser to aktive poster, men kriminaltekniske spor tyder p\u00e5 at det finnes flere slettede poster.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8111b2b e-flex e-con-boxed e-con e-parent\" data-id=\"8111b2b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a3d6ba0 elementor-widget elementor-widget-image\" data-id=\"a3d6ba0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"768\" height=\"300\" src=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_10-768x300.png\" class=\"attachment-medium_large size-medium_large wp-image-1306\" alt=\"SQLite freeblock blog image 10 \u2014 forensic analysis of database freespace in Elusive Data article\" srcset=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_10-768x300.png 768w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_10-300x117.png 300w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_10-600x234.png 600w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_10.png 802w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3ffc527 e-flex e-con-boxed e-con e-parent\" data-id=\"3ffc527\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bb3c441 elementor-widget elementor-widget-heading\" data-id=\"bb3c441\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Hvordan Freeblocks passer inn i SQLite-sideoverskrifter<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3ac908b e-flex e-con-boxed e-con e-parent\" data-id=\"3ac908b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9eed6a2 elementor-widget elementor-widget-text-editor\" data-id=\"9eed6a2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>For \u00e5 finne og analysere freeblocks m\u00e5 vi f\u00f8rst forst\u00e5 strukturen til SQLite-databasesidene. Hver side inneholder en topptekst som inneholder viktige metadata, inkludert pekere til freeblocks.<\/p>\n<p>Tabellen nedenfor viser topptekststrukturen for en 0D-sidetype:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-dcd2b55 e-flex e-con-boxed e-con e-parent\" data-id=\"dcd2b55\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5f71e4b elementor-widget elementor-widget-html\" data-id=\"5f71e4b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<table style=\"width: 100%; border-collapse: collapse;\">\r\n  <thead>\r\n    <tr style=\"background-color: #F09A35; color: white; text-align: left; font-weight: bold;\">\r\n      <th style=\"border: 1px solid #ddd; padding: 8px;\">Offset<\/th>\r\n      <th style=\"border: 1px solid #ddd; padding: 8px;\">St\u00f8rrelse<\/th>\r\n      <th style=\"border: 1px solid #ddd; padding: 8px;\">Beskrivelse<\/th>\r\n    <\/tr>\r\n  <\/thead>\r\n  <tbody>\r\n    <tr>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">0<\/td>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">1 byte<\/td>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">Sidetype<\/td>\r\n    <\/tr>\r\n    <tr>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">1<\/td>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">2 Bytes<\/td>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\"><strong>Byteoffset til den f\u00f8rste friblokken<\/strong><\/td>\r\n    <\/tr>\r\n    <tr>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">3<\/td>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">2 Bytes<\/td>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">Antall celler p\u00e5 siden<\/td>\r\n    <\/tr>\r\n    <tr>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">5<\/td>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">2 Bytes<\/td>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">Offset til f\u00f8rste byte av celleinnholdet<\/td>\r\n    <\/tr>\r\n    <tr>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">7<\/td>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">1 byte<\/td>\r\n      <td style=\"border: 1px solid #ddd; padding: 8px;\">Antall fragmenterte frie byte i celler<\/td>\r\n    <\/tr>\r\n  <\/tbody>\r\n<\/table>\r\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-617adc9 e-flex e-con-boxed e-con e-parent\" data-id=\"617adc9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d2c8366 elementor-widget elementor-widget-text-editor\" data-id=\"d2c8366\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h4>Det viktigste \u00e5 ta med seg:<\/h4>\n<p>Verdien ved offset 1 i sidehodet peker til den f\u00f8rste friblokken. Hvis denne verdien er <code>0x0000<\/code>er det ingen freeblocks p\u00e5 siden.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ec8ffe3 e-flex e-con-boxed e-con e-parent\" data-id=\"ec8ffe3\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2065f1b elementor-widget elementor-widget-heading\" data-id=\"2065f1b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Bruke hex-editorer til \u00e5 analysere friblokker<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fd95c9a e-flex e-con-boxed e-con e-parent\" data-id=\"fd95c9a\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2174179 elementor-widget elementor-widget-text-editor\" data-id=\"2174179\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>For \u00e5 finne den f\u00f8rste friblokken \u00e5pner vi databasen i en hex-editor. Den to byte store verdien ved offset 1 i sideoverskriften gir offset til friblokkens plassering.<\/p>\n<p>I eksempelet nedenfor:<\/p>\n<ul>\n<li>Hex-redigeringsprogrammet fremhever offset <code>0x03A9<\/code> (desimal 937) i r\u00f8dt, som peker p\u00e5 plasseringen av den f\u00f8rste friblokken.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-29eacb5 e-flex e-con-boxed e-con e-parent\" data-id=\"29eacb5\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-14975d8 elementor-widget elementor-widget-image\" data-id=\"14975d8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"678\" height=\"419\" src=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_0.png\" class=\"attachment-large size-large wp-image-1298\" alt=\"SQLite freeblock blog image 0 \u2014 forensic analysis of database freespace in Elusive Data article\" srcset=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_0.png 678w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_0-300x185.png 300w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_0-600x371.png 600w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2ed6426 e-flex e-con-boxed e-con e-parent\" data-id=\"2ed6426\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-76df30c elementor-widget elementor-widget-text-editor\" data-id=\"76df30c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ved \u00e5 navigere til denne forskyvningen finner du starten p\u00e5 friblokken. Nedenfor unders\u00f8ker vi cellen som ligger ved offset 937.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3959fd7 e-flex e-con-boxed e-con e-parent\" data-id=\"3959fd7\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-332578c elementor-widget elementor-widget-image\" data-id=\"332578c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"678\" height=\"419\" src=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_4.png\" class=\"attachment-large size-large wp-image-1293\" alt=\"SQLite freeblock blog image 4 \u2014 forensic analysis of database freespace in Elusive Data article\" srcset=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_4.png 678w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_4-300x185.png 300w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_4-600x371.png 600w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8702506 e-flex e-con-boxed e-con e-parent\" data-id=\"8702506\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6959e8d elementor-widget elementor-widget-text-editor\" data-id=\"6959e8d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Dekoding av Freeblock-overskrifter<\/h3>\n<p>Hver friblokk inneholder en header p\u00e5 fire byte som best\u00e5r av<\/p>\n<ol>\n<li><strong>De to f\u00f8rste byte<\/strong>: Offset til neste friblokk (<code>0x0000<\/code> hvis det ikke finnes noen).<\/li>\n<li><strong>Andre 2 byte<\/strong>: Total st\u00f8rrelse p\u00e5 friblokken, inkludert selve overskriften.<\/li>\n<\/ol>\n<h4>Eksempel:<\/h4>\n<p>Ved forskyvning <code>0x03A9<\/code>, indikerer friblokkhodet:<\/p>\n<ul>\n<li>Neste friblokk er ved offset <code>0x03EA<\/code> (desimal 1002).<\/li>\n<li>St\u00f8rrelsen p\u00e5 friblokken er <code>0x0024<\/code> (36 byte, inkludert topptekst).<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fae001e e-flex e-con-boxed e-con e-parent\" data-id=\"fae001e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8823efa elementor-widget elementor-widget-heading\" data-id=\"8823efa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Gjenopprette slettede poster ved hjelp av Freeblocks<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6f9eea4 e-flex e-con-boxed e-con e-parent\" data-id=\"6f9eea4\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-117017d elementor-widget elementor-widget-text-editor\" data-id=\"117017d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Freeblocks inneholder ofte rester av slettede poster, noe som gj\u00f8r det mulig for kriminalteknikere \u00e5 gjenopprette deler av eller hele data. I skjermbildet nedenfor er nyttelasten til en slettet post intakt og kan gjenopprettes til tross for at pekeren er fjernet.<\/p>\n<h4>Eksempel:<\/h4>\n<ul>\n<li>Den slettede posten ved offset <code>0x03A9<\/code> inneholder beskjeden: \"Ikke mye. Hvordan g\u00e5r det med deg?\"<\/li>\n<li>N\u00f8kkelfelter forblir intakte, inkludert meldingsinnholdet, selv om andre metadata har blitt overskrevet.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8cd6d16 e-flex e-con-boxed e-con e-parent\" data-id=\"8cd6d16\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7a70236 elementor-widget elementor-widget-image\" data-id=\"7a70236\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"419\" src=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_5.png\" class=\"attachment-large size-large wp-image-1294\" alt=\"SQLite freeblock blog image 5 \u2014 forensic analysis of database freespace in Elusive Data article\" srcset=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_5.png 678w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_5-300x185.png 300w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_5-600x371.png 600w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c24e104 e-flex e-con-boxed e-con e-parent\" data-id=\"c24e104\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7a613fa elementor-widget elementor-widget-text-editor\" data-id=\"7a613fa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Vi analyserer p\u00e5f\u00f8lgende freeblocks for \u00e5 avdekke flere slettede poster. Ved offset <code>0x03EA<\/code>avsl\u00f8rer freeblock-toppteksten:<\/p>\n<ul>\n<li>St\u00f8rrelsen p\u00e5 friblokken er <code>0x0016<\/code> (22 byte).<\/li>\n<li>Dette er den siste friblokken i kjeden, som indikert av <code>0x0000<\/code> i det neste friblokk-pekerfeltet.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-10a67c1 e-flex e-con-boxed e-con e-parent\" data-id=\"10a67c1\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7c55268 elementor-widget elementor-widget-image\" data-id=\"7c55268\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"419\" src=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_6.png\" class=\"attachment-large size-large wp-image-1299\" alt=\"SQLite freeblock blog image 6 \u2014 forensic analysis of database freespace in Elusive Data article\" srcset=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_6.png 678w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_6-300x185.png 300w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_6-600x371.png 600w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d26dc8e e-flex e-con-boxed e-con e-parent\" data-id=\"d26dc8e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d7e870b elementor-widget elementor-widget-text-editor\" data-id=\"d7e870b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Skjermbildet nedenfor viser hele celleomr\u00e5det i den andre friblokken i kjeden, der den slettede meldingen var \"Hi Andy!\"<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-878b7a0 e-flex e-con-boxed e-con e-parent\" data-id=\"878b7a0\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0dddffb elementor-widget elementor-widget-image\" data-id=\"0dddffb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"419\" src=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_7png.png\" class=\"attachment-large size-large wp-image-1300\" alt=\"SQLite freeblock blog image 7 \u2014 forensic analysis of database freespace in Elusive Data article\" srcset=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_7png.png 678w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_7png-300x185.png 300w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_7png-600x371.png 600w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8194c40 e-flex e-con-boxed e-con e-parent\" data-id=\"8194c40\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d41c1fe elementor-widget elementor-widget-heading\" data-id=\"d41c1fe\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Identifisere flere slettede poster<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-bb25aaf e-flex e-con-boxed e-con e-parent\" data-id=\"bb25aaf\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ef28520 elementor-widget elementor-widget-text-editor\" data-id=\"ef28520\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Men det er tilfeldigvis \u00e9n slettet post til p\u00e5 denne siden som ikke er referert til av freeblock-kjeden. Hvis vi ser tilbake p\u00e5 sidehodet, var det bare to poster p\u00e5 denne siden i henhold til to-byte-verdien ved offset 3 (<code>0x00002<\/code>). Og siden det bare er to poster, er det bare to pekere i pekerarrayen. Disse to pekerne peker til post #2 - \"Hei, hva skjer?\" og post #4 - \"Hei, jeg lurte p\u00e5 om du har noen Scooby Snax.\" Du vil kanskje legge merke til at det ligger en annen lang melding lenger opp p\u00e5 siden.<\/p>\n<p>Den to byte store verdien ved offset 5 i sidehodet er offset til cellens innholdsomr\u00e5de, der neste post vil bli skrevet, med mindre den f\u00e5r plass i en av friblokkene. Denne verdien er <code>0x0363<\/code> som er desimal offset 867.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-890d766 e-flex e-con-boxed e-con e-parent\" data-id=\"890d766\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5ec77a7 elementor-widget elementor-widget-image\" data-id=\"5ec77a7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"419\" src=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_8png.png\" class=\"attachment-large size-large wp-image-1304\" alt=\"SQLite freeblock blog image 8 \u2014 forensic analysis of database freespace in Elusive Data article\" srcset=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_8png.png 678w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_8png-300x185.png 300w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_8png-600x371.png 600w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7eb40a6 e-flex e-con-boxed e-con e-parent\" data-id=\"7eb40a6\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-748c742 elementor-widget elementor-widget-text-editor\" data-id=\"748c742\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Pilen i skjermbildet ovenfor peker til sideoffset 867. Dette er starten p\u00e5 celleinnholdet, noe som betyr at neste post vil bli lagt til rett over denne posten. Den slettede posten over denne inneholder meldingen \"Jeg fikk tilfeldigvis inn en ny leveranse i g\u00e5r kveld. Du har flaks. Hvor mye trenger du?\"<\/p>\n<p>Databasen anser disse dataene som uallokert plass. Den kan like gjerne fylles med <code>0x00<\/code> siden det ikke finnes noen peker i pekerarrayen som adresserer den.\u00a0<br \/><br \/>Hvis det legges til en post som er for stor til \u00e5 f\u00e5 plass innenfor de to friblokkene p\u00e5 siden, vil den overskrive meldingen, som tilfeldigvis er post #5.\u00a0<\/p>\n<p>La oss se hvordan det ser ut n\u00e5 som vi har identifisert de to freeblockene sammen med den tredje slettede posten som venter p\u00e5 \u00e5 bli overskrevet:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-601e81d e-flex e-con-boxed e-con e-parent\" data-id=\"601e81d\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-26e3ed0 elementor-widget elementor-widget-image\" data-id=\"26e3ed0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"419\" src=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_9.png\" class=\"attachment-large size-large wp-image-1305\" alt=\"SQLite freeblock blog image 9 \u2014 forensic analysis of database freespace in Elusive Data article\" srcset=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_9.png 678w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_9-300x185.png 300w, https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_blog_image_9-600x371.png 600w\" sizes=\"(max-width: 678px) 100vw, 678px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7840c3b e-flex e-con-boxed e-con e-parent\" data-id=\"7840c3b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4b62ec0 elementor-widget elementor-widget-text-editor\" data-id=\"4b62ec0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Etter \u00e5 ha analysert databasen i r\u00e5format, kan vi konkludere med at den inneholdt mer enn bare de to \"live\"-postene som databasevisningen viste.\u00a0<\/p>\n<p>Opptak #1 var sannsynligvis meldingen \"Hei Andy!\", mens opptak #3 sannsynligvis var meldingen \"Ikke mye. Hvordan har du det?\". Record #5 har fortsatt sitt recordnummer i cellen som er identifisert som meldingen \"Jeg fikk tilfeldigvis inn en ny forsyning i g\u00e5r kveld. Du har flaks. Hvor mye trenger du?\"<\/p>\n<p>\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0c7c39b e-flex e-con-boxed e-con e-parent\" data-id=\"0c7c39b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cbae9bf elementor-widget elementor-widget-heading\" data-id=\"cbae9bf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Konklusjon<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1a75ee2 e-flex e-con-boxed e-con e-parent\" data-id=\"1a75ee2\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d959fe0 elementor-widget elementor-widget-text-editor\" data-id=\"d959fe0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Freeblocks er et kraftfullt verkt\u00f8y i kriminaltekniske unders\u00f8kelser, og gir innsyn i slettede poster og data som ikke er allokert. Ved \u00e5 beherske disse teknikkene kan etterforskere avdekke de digitale sporene som databaser etterlater seg.<\/p><p>Er du klar for \u00e5 ta SQLite-etterforskningskunnskapene dine til neste niv\u00e5? Utforsk v\u00e5re avanserte oppl\u00e6ringsprogrammer, eller kontakt oss for \u00e5 finne ut hvordan vi kan hjelpe deg med \u00e5 bli en kriminalteknisk ekspert.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Avsl\u00f8r hemmelighetene bak SQLite freeblocks, og l\u00e6r hvordan du gjenoppretter slettede poster ved hjelp av kriminaltekniske teknikker.<\/p>","protected":false},"author":1,"featured_media":1271,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[21],"tags":[57],"class_list":["post-992","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mobile-forensics","tag-sqlite-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Recovering Deleted Data from SQLite: Navigating the Freeblock Chain<\/title>\n<meta name=\"description\" content=\"Learn how to recover deleted data from SQLite databases by understanding and navigating the freeblock chain. This guide provides forensic investigators with essential techniques for data recovery.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/elusivedata.io\/nb\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/\" \/>\n<meta property=\"og:locale\" content=\"nb_NO\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Recovering Deleted Data from SQLite: Navigating the Freeblock Chain\" \/>\n<meta property=\"og:description\" content=\"Learn how to recover deleted data from SQLite databases by understanding and navigating the freeblock chain. This guide provides forensic investigators with essential techniques for data recovery.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/elusivedata.io\/nb\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/\" \/>\n<meta property=\"og:site_name\" content=\"Elusive Data\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-28T20:09:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-18T18:04:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_chain-1024x574.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"574\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"James Eichbaum\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Skrevet av\" \/>\n\t<meta name=\"twitter:data1\" content=\"James Eichbaum\" \/>\n\t<meta name=\"twitter:label2\" content=\"Ansl. lesetid\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/\"},\"author\":{\"name\":\"James Eichbaum\",\"@id\":\"https:\\\/\\\/elusivedata.io\\\/#\\\/schema\\\/person\\\/2c00b8313d6aef321fd69bf82e2aa436\"},\"headline\":\"Recovering Deleted Data from SQLite: Navigating the Freeblock Chain\",\"datePublished\":\"2024-11-28T20:09:37+00:00\",\"dateModified\":\"2025-07-18T18:04:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/\"},\"wordCount\":1036,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/elusivedata.io\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/elusivedata.io\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/freeblock_chain.png\",\"keywords\":[\"SQLite Databases\"],\"articleSection\":[\"Mobile Forensics\"],\"inLanguage\":\"nb-NO\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/\",\"url\":\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/\",\"name\":\"Recovering Deleted Data from SQLite: Navigating the Freeblock Chain\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elusivedata.io\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/elusivedata.io\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/freeblock_chain.png\",\"datePublished\":\"2024-11-28T20:09:37+00:00\",\"dateModified\":\"2025-07-18T18:04:34+00:00\",\"description\":\"Learn how to recover deleted data from SQLite databases by understanding and navigating the freeblock chain. This guide provides forensic investigators with essential techniques for data recovery.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/#breadcrumb\"},\"inLanguage\":\"nb-NO\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nb-NO\",\"@id\":\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/#primaryimage\",\"url\":\"https:\\\/\\\/elusivedata.io\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/freeblock_chain.png\",\"contentUrl\":\"https:\\\/\\\/elusivedata.io\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/freeblock_chain.png\",\"width\":2912,\"height\":1632,\"caption\":\"Step-by-step guide to recovering deleted data from SQLite databases using the freeblock chain.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/elusivedata.io\\\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/elusivedata.io\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recovering Deleted Data from SQLite: Navigating the Freeblock Chain\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/elusivedata.io\\\/#website\",\"url\":\"https:\\\/\\\/elusivedata.io\\\/\",\"name\":\"ElusiveData\",\"description\":\"Excellence in Digital Forensics Training and Consulting\",\"publisher\":{\"@id\":\"https:\\\/\\\/elusivedata.io\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/elusivedata.io\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nb-NO\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/elusivedata.io\\\/#organization\",\"name\":\"ElusiveData\",\"url\":\"https:\\\/\\\/elusivedata.io\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nb-NO\",\"@id\":\"https:\\\/\\\/elusivedata.io\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/elusivedata.io\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/Asset-3_2x-scaled.png\",\"contentUrl\":\"https:\\\/\\\/elusivedata.io\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/Asset-3_2x-scaled.png\",\"width\":2560,\"height\":370,\"caption\":\"ElusiveData\"},\"image\":{\"@id\":\"https:\\\/\\\/elusivedata.io\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.youtube.com\\\/@elusivedata\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/elusivedata.io\\\/#\\\/schema\\\/person\\\/2c00b8313d6aef321fd69bf82e2aa436\",\"name\":\"James Eichbaum\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nb-NO\",\"@id\":\"https:\\\/\\\/elusivedata.io\\\/wp-content\\\/plugins\\\/ld-dashboard\\\/public\\\/img\\\/img_avatar.png\",\"url\":\"https:\\\/\\\/elusivedata.io\\\/wp-content\\\/plugins\\\/ld-dashboard\\\/public\\\/img\\\/img_avatar.png\",\"contentUrl\":\"https:\\\/\\\/elusivedata.io\\\/wp-content\\\/plugins\\\/ld-dashboard\\\/public\\\/img\\\/img_avatar.png\",\"caption\":\"James Eichbaum\"},\"sameAs\":[\"http:\\\/\\\/elusivedata.io\"],\"url\":\"https:\\\/\\\/elusivedata.io\\\/nb\\\/author\\\/eichbaumjamesgmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Gjenopprette slettede data fra SQLite: Navigere i freeblock-kjeden","description":"L\u00e6r hvordan du gjenoppretter slettede data fra SQLite-databaser ved \u00e5 forst\u00e5 og navigere i freeblock-kjeden. Denne veiledningen gir kriminalteknikere viktige teknikker for datagjenoppretting.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/elusivedata.io\/nb\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/","og_locale":"nb_NO","og_type":"article","og_title":"Recovering Deleted Data from SQLite: Navigating the Freeblock Chain","og_description":"Learn how to recover deleted data from SQLite databases by understanding and navigating the freeblock chain. This guide provides forensic investigators with essential techniques for data recovery.","og_url":"https:\/\/elusivedata.io\/nb\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/","og_site_name":"Elusive Data","article_published_time":"2024-11-28T20:09:37+00:00","article_modified_time":"2025-07-18T18:04:34+00:00","og_image":[{"width":1024,"height":574,"url":"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_chain-1024x574.png","type":"image\/png"}],"author":"James Eichbaum","twitter_card":"summary_large_image","twitter_misc":{"Skrevet av":"James Eichbaum","Ansl. lesetid":"7 minutter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/#article","isPartOf":{"@id":"https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/"},"author":{"name":"James Eichbaum","@id":"https:\/\/elusivedata.io\/#\/schema\/person\/2c00b8313d6aef321fd69bf82e2aa436"},"headline":"Recovering Deleted Data from SQLite: Navigating the Freeblock Chain","datePublished":"2024-11-28T20:09:37+00:00","dateModified":"2025-07-18T18:04:34+00:00","mainEntityOfPage":{"@id":"https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/"},"wordCount":1036,"commentCount":0,"publisher":{"@id":"https:\/\/elusivedata.io\/#organization"},"image":{"@id":"https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/#primaryimage"},"thumbnailUrl":"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_chain.png","keywords":["SQLite Databases"],"articleSection":["Mobile Forensics"],"inLanguage":"nb-NO","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/","url":"https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/","name":"Gjenopprette slettede data fra SQLite: Navigere i freeblock-kjeden","isPartOf":{"@id":"https:\/\/elusivedata.io\/#website"},"primaryImageOfPage":{"@id":"https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/#primaryimage"},"image":{"@id":"https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/#primaryimage"},"thumbnailUrl":"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_chain.png","datePublished":"2024-11-28T20:09:37+00:00","dateModified":"2025-07-18T18:04:34+00:00","description":"L\u00e6r hvordan du gjenoppretter slettede data fra SQLite-databaser ved \u00e5 forst\u00e5 og navigere i freeblock-kjeden. Denne veiledningen gir kriminalteknikere viktige teknikker for datagjenoppretting.","breadcrumb":{"@id":"https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/#breadcrumb"},"inLanguage":"nb-NO","potentialAction":[{"@type":"ReadAction","target":["https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/"]}]},{"@type":"ImageObject","inLanguage":"nb-NO","@id":"https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/#primaryimage","url":"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_chain.png","contentUrl":"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/freeblock_chain.png","width":2912,"height":1632,"caption":"Step-by-step guide to recovering deleted data from SQLite databases using the freeblock chain."},{"@type":"BreadcrumbList","@id":"https:\/\/elusivedata.io\/recovering-deleted-data-from-sqlite-navigating-the-freeblock-chain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/elusivedata.io\/"},{"@type":"ListItem","position":2,"name":"Recovering Deleted Data from SQLite: Navigating the Freeblock Chain"}]},{"@type":"WebSite","@id":"https:\/\/elusivedata.io\/#website","url":"https:\/\/elusivedata.io\/","name":"ElusiveData","description":"Fremragende oppl\u00e6ring og r\u00e5dgivning innen digital etterforskning","publisher":{"@id":"https:\/\/elusivedata.io\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/elusivedata.io\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nb-NO"},{"@type":"Organization","@id":"https:\/\/elusivedata.io\/#organization","name":"ElusiveData","url":"https:\/\/elusivedata.io\/","logo":{"@type":"ImageObject","inLanguage":"nb-NO","@id":"https:\/\/elusivedata.io\/#\/schema\/logo\/image\/","url":"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/Asset-3_2x-scaled.png","contentUrl":"https:\/\/elusivedata.io\/wp-content\/uploads\/2024\/11\/Asset-3_2x-scaled.png","width":2560,"height":370,"caption":"ElusiveData"},"image":{"@id":"https:\/\/elusivedata.io\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.youtube.com\/@elusivedata"]},{"@type":"Person","@id":"https:\/\/elusivedata.io\/#\/schema\/person\/2c00b8313d6aef321fd69bf82e2aa436","name":"James Eichbaum","image":{"@type":"ImageObject","inLanguage":"nb-NO","@id":"https:\/\/elusivedata.io\/wp-content\/plugins\/ld-dashboard\/public\/img\/img_avatar.png","url":"https:\/\/elusivedata.io\/wp-content\/plugins\/ld-dashboard\/public\/img\/img_avatar.png","contentUrl":"https:\/\/elusivedata.io\/wp-content\/plugins\/ld-dashboard\/public\/img\/img_avatar.png","caption":"James Eichbaum"},"sameAs":["http:\/\/elusivedata.io"],"url":"https:\/\/elusivedata.io\/nb\/author\/eichbaumjamesgmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/elusivedata.io\/nb\/wp-json\/wp\/v2\/posts\/992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elusivedata.io\/nb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elusivedata.io\/nb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elusivedata.io\/nb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elusivedata.io\/nb\/wp-json\/wp\/v2\/comments?post=992"}],"version-history":[{"count":59,"href":"https:\/\/elusivedata.io\/nb\/wp-json\/wp\/v2\/posts\/992\/revisions"}],"predecessor-version":[{"id":1437,"href":"https:\/\/elusivedata.io\/nb\/wp-json\/wp\/v2\/posts\/992\/revisions\/1437"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/elusivedata.io\/nb\/wp-json\/wp\/v2\/media\/1271"}],"wp:attachment":[{"href":"https:\/\/elusivedata.io\/nb\/wp-json\/wp\/v2\/media?parent=992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elusivedata.io\/nb\/wp-json\/wp\/v2\/categories?post=992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elusivedata.io\/nb\/wp-json\/wp\/v2\/tags?post=992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}