{"id":108336,"date":"2026-02-11T15:52:06","date_gmt":"2026-02-11T15:52:06","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?post_type=podcast&#038;p=108336"},"modified":"2026-02-12T15:56:19","modified_gmt":"2026-02-12T15:56:19","slug":"rollback-vs-roll-forward-in-databases","status":"publish","type":"podcast","link":"https:\/\/www.red-gate.com\/simple-talk\/podcasts\/rollback-vs-roll-forward-in-databases\/","title":{"rendered":"Rollback vs Roll Forward in Databases"},"content":{"rendered":"\n<div class=\"mb-2xl\">\n            <button data-youtube-url=\"https:\/\/www.youtube.com\/embed\/5uln_0J_ncU?si=gDtoRb7lvKY6C0t7\" id=\"podcastModalButton\" class=\"relative aspect-[16\/9] bg-gray-900 flex items-center justify-center flex-col gap-md w-full p-md\">\n                            <img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/02\/ST_Podcast_Rollback_vs_Roll_Forward_2026_YT_Cover-1024x576.png\" class=\"object-cover absolute inset-0 w-full h-full wp-post-image\" alt=\"\" srcset=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/02\/ST_Podcast_Rollback_vs_Roll_Forward_2026_YT_Cover-1024x576.png 1024w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/02\/ST_Podcast_Rollback_vs_Roll_Forward_2026_YT_Cover-300x169.png 300w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/02\/ST_Podcast_Rollback_vs_Roll_Forward_2026_YT_Cover-768x432.png 768w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2026\/02\/ST_Podcast_Rollback_vs_Roll_Forward_2026_YT_Cover.png 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>                        <svg class=\"w-12 h-auto absolute m-auto text-base-white\" width=\"20\" height=\"20\" viewBox=\"0 0 20 20\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                <path d=\"M10 0C3.5 0 0 3.5 0 10C0 16.5 3.5 20 10 20C16.5 20 20 16.5 20 10C20 3.5 16.5 0 10 0ZM11.47 12.71C10.08 13.51 8.64 14.11 7.25 14.5C7.06 13.13 6.95 11.61 6.95 10C6.95 8.39 7.06 6.87 7.25 5.5C8.64 5.89 10.08 6.49 11.47 7.29C12.86 8.09 14.06 9.02 15.05 10C14.07 10.98 12.87 11.9 11.47 12.71Z\" fill=\"currentColor\" \/>\n            <\/svg>\n\n        <\/button>\n    \n    <dialog id=\"podcastModal\" class=\"\">\n        <div class=\"bg-base-black bg-opacity-80 fixed inset-0 z-10 h-full w-full max-w-full max-h-full flex items-center justify-center\">\n            <div class=\"mx-auto relative w-full container\">\n                <div class=\"flex overflow-hidden rounded-xs bg-base-black\">\n                    <div class=\"relative aspect-[16\/9] w-full\">\n                        <iframe loading=\"lazy\" id=\"podcastYoutubeVideo\" class=\"absolute inset-0 w-full h-full\" width=\"560\" height=\"315\" src=\"\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n                    <\/div>\n                <\/div>\n                <button id=\"closeModalButton\" class=\"absolute -top-12 -right-0 w-auto h-12 flex items-center justify-center\">\n                    <svg class=\"w-8 h-8\" width=\"20\" height=\"20\" viewBox=\"0 0 20 20\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                        <path d=\"M10 0C3.5 0 0 3.5 0 10C0 16.5 3.5 20 10 20C16.5 20 20 16.5 20 10C20 3.5 16.5 0 10 0ZM13.37 11.95C13.89 12.47 14.4 12.98 14.91 13.65C14.77 13.88 14.59 14.11 14.38 14.32C14.16 14.54 13.9 14.75 13.65 14.91C13.06 14.43 12.51 13.91 11.96 13.36L10.01 11.41L8.06 13.36C7.54 13.88 7.03 14.39 6.36 14.9C6.13 14.76 5.9 14.58 5.69 14.37C5.47 14.15 5.26 13.89 5.1 13.64C5.58 13.05 6.1 12.5 6.65 11.95L8.6 10L6.65 8.05C6.13 7.53 5.62 7.02 5.11 6.35C5.25 6.12 5.43 5.89 5.64 5.68C5.86 5.46 6.12 5.25 6.37 5.09C6.96 5.57 7.51 6.09 8.06 6.64L10.01 8.59L11.96 6.64C12.48 6.12 12.99 5.61 13.66 5.1C13.89 5.24 14.12 5.42 14.33 5.63C14.55 5.85 14.76 6.11 14.92 6.36C14.44 6.95 13.92 7.5 13.37 8.05L11.42 10L13.37 11.95Z\" fill=\"white\" \/>\n                    <\/svg>\n                <\/button>\n            <\/div>\n        <\/div>\n    <\/dialog>\n    \n            <div class=\"flex flex-wrap gap-4 items-center mt-3xl\">\n            <p class=\"mb-0 leading-tight font-bold\">Listen on:<\/p>\n            <div class=\"flex flex-wrap gap-xl\">\n                                    <a class=\"duration-200 hover:opacity-70\" href=\"https:\/\/open.spotify.com\/show\/4sLQQR7DgYDPj2Ob1muIgU\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/spotify-podcast.png?v=2\" alt=\"Listen on Spotify\">\n                    <\/a>\n                                                    <a class=\"duration-200 hover:opacity-70\" href=\"https:\/\/podcasts.apple.com\/gb\/podcast\/rollback-vs-roll-forward-in-databases\/id1773262159?i=1000749269301\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/apple-podcast.png?v=2\" alt=\"Listen on Apple Podcasts\">\n                    <\/a>\n                                                    <a class=\"duration-200 hover:opacity-70\" href=\"https:\/\/sites.libsyn.com\/537157\/rollback-vs-roll-forward-in-databases\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/libsyn-podcast.png?v=2\" alt=\"Listen on Libsyn\">\n                    <\/a>\n                                                    <a class=\"duration-200 hover:opacity-70 flex-shrink-0\" href=\"https:\/\/music.amazon.com\/podcasts\/bb23354a-9850-428f-9cb3-83235ef279c6\/episodes\/78e4ae6c-7eba-4d91-8a2e-4d2af61b161c\/simple-talks-rollback-vs-roll-forward-in-databases\" target=\"_blank\">\n                        <img decoding=\"async\" class=\"h-10 w-auto max-w-full\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/themes\/simple-talk-theme-2024\/assets\/images\/sharing\/amazon-podcast.png?v=2\" alt=\"Listen on Amazon Music\">\n                    <\/a>\n                            <\/div>\n        <\/div>\n    \n    <\/div>\n\n\n<p>Rollbacks&nbsp;act as an \u2018undo\u2019 for databases, but why&nbsp;are they important, what happens if you&nbsp;can\u2019t&nbsp;roll back, and&nbsp;how do you prevent even&nbsp;needing to in the first place? Steve, Kellyn, Grant &amp; Pat try to answer these questions \u2013 and more.&nbsp;<\/p>\n\n\n\n<p>Recorded on-site at Redgate HQ in Cambridge, UK.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Why are rollbacks important, what happens if you can&#8217;t roll back, and how do you prevent needing to in the first place?&hellip;<\/p>\n","protected":false},"featured_media":108338,"template":"","tags":[4168,4170,4150,4151],"podcast_category":[159198],"podcast_season":[],"class_list":["post-108336","podcast","type-podcast","status-publish","has-post-thumbnail","hentry","tag-database","tag-database-administration","tag-sql","tag-sql-server","podcast_category-advochats"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast\/108336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/podcast"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/108338"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=108336"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=108336"},{"taxonomy":"podcast_category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast_category?post=108336"},{"taxonomy":"podcast_season","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/podcast_season?post=108336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}