{"id":1160,"date":"2007-10-06T01:00:37","date_gmt":"2007-10-06T01:00:37","guid":{"rendered":"\/blogs\/paul\/post\/Search-Engine-QA-6-Using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup.aspx"},"modified":"2007-10-06T01:00:37","modified_gmt":"2007-10-06T01:00:37","slug":"search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/","title":{"rendered":"Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup"},"content":{"rendered":"


\n

Here’s a really interesting question that was in my search engine logs yesterday – if I have a transaction that runs and completes while a backup is running, will the complete transaction be in the backup? The answer is…. it depends!<\/P>
\n

In terms of what gets backed up, the way a full backup works is:<\/P>
\n


    \n
  1. Note the transaction log’s LSN (Log Sequence Number)
    \n
  2. Read all allocated extents in the various data files
    \n
  3. Note the LSN again
    \n
  4. Read all the transaction log between the starting LSN and the ending LSN<\/LI><\/OL>
    \n

    Any transaction that commits before or on the LSN read in step 3 will be fully reflected when the database is restored. If not, the transaction will be undone. So you can’t just go by the completion time of the backup and the completion time of the transaction. The transaction may well commit before the backup operation completes, but it may complete during step 4, and so it will get rolled back during a restore. In this case, it’s necessary to take a log backup as well and restore that too to make the transaction be fully reflected after a restore.<\/P>
    \n

    As you know I always like to prove things  – so here’s my proof of what I just said. I’m going to use the AdventureWorks<\/FONT> database to do this. First thing is to set it to full recovery mode (and take the first full backup to start full recovery mode logging):<\/P>
    \n


    \n

    ALTER<\/FONT><\/FONT> <\/FONT>DATABASE<\/FONT> AdventureWorks <\/FONT>SET<\/FONT> <\/FONT>RECOVERY<\/FONT> <\/FONT>FULL<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    BACKUP<\/FONT><\/FONT> <\/FONT>DATABASE<\/FONT> AdventureWorks <\/FONT>TO<\/FONT> <\/FONT>DISK<\/FONT>=<\/FONT>‘C:\\SQLskills\\AdventureWorks.bck’ <\/FONT>WITH<\/FONT> <\/FONT>INIT<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/FONT><\/P><\/BLOCKQUOTE>
    \n

    Now I’m going to flush out the backup history tables in MSDB:<\/P>
    \n


    \n

    USE<\/FONT><\/FONT> msdb<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/P><\/FONT>
    \n

    EXEC<\/FONT><\/FONT> <\/FONT>sp_delete_backuphistory<\/FONT> <\/FONT>’10\/6\/07′<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/FONT><\/P><\/BLOCKQUOTE><\/FONT>
    \n

    I’ve got a really contrived example that I’m going to use to show whether my transaction is wholely contained in the full backup. Using the HumanResources.Employee<\/FONT> table, there’s a column VacationHours<\/FONT> which I’m going to set to 0 and then force all the changes pages to disk. This is my base state:<\/P>
    \n


    \n

    UPDATE<\/FONT><\/FONT> AdventureWorks<\/FONT>.<\/FONT>HumanResources<\/FONT>.<\/FONT>Employee <\/FONT>SET<\/FONT> VacationHours <\/FONT>=<\/FONT> 0<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/P><\/FONT>
    \n

    CHECKPOINT<\/FONT><\/FONT>;<\/FONT><\/P><\/FONT>
    \n

    GO<\/FONT><\/P><\/BLOCKQUOTE>
    \n

    My contrived transaction is going to be in a tight loop updating all the rows in the table, which will generate lots of transaction log, and timed to complete just before the backup completes (i.e. in stage 4). In one connection I start the backup:<\/P>
    \n


    \n

    BACKUP<\/FONT><\/FONT> <\/FONT>DATABASE<\/FONT> AdventureWorks <\/FONT>TO<\/FONT> <\/FONT>DISK<\/FONT>=<\/FONT>‘C:\\SQLskills\\AdventureWorks.bck’ <\/FONT>WITH<\/FONT> <\/FONT>INIT<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    SELECT<\/FONT><\/FONT> <\/FONT>GETDATE<\/FONT> <\/FONT>();<\/P><\/FONT><\/FONT>
    \n

    GO<\/P><\/FONT><\/BLOCKQUOTE>
    \n

    and in another I start my contrived transaction, after starting the backup:<\/P>
    \n


    \n

    BEGIN<\/FONT><\/FONT> <\/FONT>TRAN<\/FONT><\/P>
    \n

    DECLARE<\/FONT><\/FONT> @a <\/FONT>INT<\/FONT><\/P>
    \n

    DECLARE<\/FONT><\/FONT> @b <\/FONT>INT<\/FONT><\/P>
    \n

    SELECT<\/FONT><\/FONT> @a <\/FONT>=<\/FONT> 1<\/FONT><\/P><\/FONT><\/FONT>
    \n

    WHILE<\/FONT><\/FONT> <\/FONT>(<\/FONT>@a <\/FONT><<\/FONT> 6<\/FONT>)<\/P><\/FONT><\/FONT>
    \n

    BEGIN<\/P><\/FONT>
    \n


    \n

    <\/FONT>SELECT<\/FONT> @b <\/FONT>=<\/FONT><\/FONT> 1<\/FONT><\/P>
    \n

    <\/FONT>WHILE<\/FONT> <\/FONT>(<\/FONT>@b <\/FONT><<\/FONT> 201<\/FONT>)<\/P><\/FONT><\/FONT>
    \n

    <\/FONT>BEGIN<\/FONT><\/P><\/FONT>
    \n


    \n

    <\/FONT>UPDATE<\/FONT> AdventureWorks<\/FONT>.<\/FONT>HumanResources<\/FONT>.<\/FONT>Employee <\/FONT>SET<\/FONT> VacationHours <\/FONT>=<\/FONT><\/FONT> @b<\/FONT><\/P>
    \n

    <\/FONT>SELECT<\/FONT> @b<\/FONT>=<\/FONT>@b<\/FONT>+<\/FONT><\/FONT>1<\/FONT><\/P><\/BLOCKQUOTE>
    \n

    <\/FONT>END<\/FONT><\/P><\/BLOCKQUOTE><\/FONT>
    \n

    <\/FONT>SELECT<\/FONT> @a<\/FONT>=<\/FONT>@a<\/FONT>+<\/FONT>1<\/P><\/FONT><\/FONT>
    \n

    END<\/FONT><\/P>
    \n

    COMMIT<\/FONT><\/FONT> <\/FONT>TRAN<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    SELECT<\/FONT><\/FONT> <\/FONT>GETDATE<\/FONT> <\/FONT>();<\/P><\/FONT><\/FONT>
    \n

    GO<\/P><\/FONT><\/BLOCKQUOTE>
    \n

    It’s not pretty but it does the job. The backup finishes at 2007-10-05 17:42:38.983<\/FONT><\/FONT> and the transaction finishes at 2007-10-05 17:42:38.107<\/FONT><\/FONT> – before<\/EM> the backup finishes. Remember I set the VacationHours<\/FONT> all to zero before running my transaction – let’s check the transaction did actually change them:<\/P>
    \n


    \n

    SELECT<\/FONT><\/FONT> <\/FONT>MAX<\/FONT> <\/FONT>(<\/FONT>VacationHours<\/FONT>)<\/FONT> <\/FONT>FROM<\/FONT> AdventureWorks<\/FONT>.<\/FONT>HumanResources<\/FONT>.<\/FONT>Employee<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/FONT><\/P><\/BLOCKQUOTE>
    \n

    <\/FONT>This returns 200 – which is what I’d expect. But is the transaction wholely contained in the backup? Let’s look at the backup history to find out the last LSN that was captured in the full backup:<\/P>
    \n


    \n

    SELECT<\/FONT><\/FONT> Backup_Start_Date<\/FONT>,<\/FONT> Backup_Finish_Date<\/FONT>,<\/FONT> First_LSN<\/FONT>,<\/FONT> Last_LSN<\/FONT><\/P><\/FONT><\/FONT>
    \n

    FROM<\/FONT><\/FONT> msdb<\/FONT>.<\/FONT>dbo<\/FONT>.<\/FONT>backupset <\/FONT>WHERE<\/FONT> database_name <\/FONT>=<\/FONT> <\/FONT>‘AdventureWorks’<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/P><\/FONT><\/FONT><\/BLOCKQUOTE>
    \n

    And the output we get is:<\/P>
    \n


    \n

    Backup_Start_Date       Backup_Finish_Date      First_LSN           Last_LSN
    ———————– ———————– ——————- ——————-
    2007-10-05 17:42:22.000 2007-10-05 17:42:38.000 86000000001600029   91000000625600001<\/FONT>
    <\/P><\/BLOCKQUOTE>
    \n

    The LSNs are in decimal, so we need to convert the three numbers to hex so we can compare them to what’s in the log – giving: 5B:1870:1. This is the LSN of the last log record that was backed up in the full backup. Now let’s take a look at the transaction log for AdventureWorks<\/FONT> using the undocumented fn_dblog<\/FONT> function. This is undocumented but very well known. It’s a fully composable alternative to using the old DBCC LOG<\/FONT> command.<\/FONT><\/P>
    \n


    \n

    USE<\/FONT><\/FONT> AdventureWorks<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/FONT><\/P>
    \n

    <\/FONT>SELECT<\/FONT><\/FONT> [Current LSN]<\/FONT>,<\/FONT> Operation<\/FONT>,<\/FONT> [Transaction ID]<\/FONT>,<\/FONT> AllocUnitName <\/FONT><\/FONT>FROM<\/FONT> fn_dblog <\/FONT>(NULL,<\/FONT> <\/FONT>NULL);<\/P><\/FONT><\/FONT>
    \n

    GO<\/P><\/FONT><\/BLOCKQUOTE>
    \n

    The log record at that LSN is:<\/P>
    \n


    \n

    00000058:00001870:0001  LOP_MODIFY_ROW     0000:00001338  HumanResources.Employee.PK_Employee_EmployeeID<\/FONT>
    <\/P><\/BLOCKQUOTE>
    \n

    This is obviously in the middle of my contrived transaction – showing that it isn’t all in the full backup. The end of the transaction isn’t until way later in the log:<\/P>
    \n


    \n

    0000005e:00000628:01b1  LOP_MODIFY_ROW     0000:00001338  HumanResources.Employee.PK_Employee_EmployeeID
    0000005e:00000628:01b2  LOP_COMMIT_XACT    0000:00001338  NULL<\/FONT>
    <\/P><\/BLOCKQUOTE>
    \n

    Before I do anything else, I want to take a log backup to preserve my transaction:<\/P>
    \n


    \n

    BACKUP<\/FONT><\/FONT> <\/FONT>LOG<\/FONT> AdventureWorks <\/FONT>TO<\/FONT> <\/FONT>DISK<\/FONT>=<\/FONT>‘C:\\SQLskills\\AdventureWorks_Log.bck’ <\/FONT>WITH<\/FONT> <\/FONT>INIT<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/P><\/FONT><\/BLOCKQUOTE>
    \n

    Now I want to restore the full backup and really show that my transaction isn’t all in there:<\/P><\/FONT><\/FONT>
    \n


    \n

    USE<\/FONT><\/FONT> <\/FONT>master<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/P><\/FONT>
    \n

    RESTORE<\/FONT><\/FONT> <\/FONT>DATABASE<\/FONT> AdventureWorks <\/FONT>FROM<\/FONT> <\/FONT>DISK<\/FONT>=<\/FONT>‘C:\\SQLskills\\AdventureWorks.bck’ <\/FONT>WITH<\/FONT> <\/FONT>REPLACE<\/FONT>,<\/FONT> <\/FONT>RECOVERY<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/FONT><\/P><\/BLOCKQUOTE>
    \n


    \n

    SELECT<\/FONT><\/FONT> <\/FONT>MAX<\/FONT> <\/FONT>(<\/FONT>VacationHours<\/FONT>)<\/FONT> <\/FONT>FROM<\/FONT> AdventureWorks<\/FONT>.<\/FONT>HumanResources<\/FONT>.<\/FONT>Employee<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/FONT><\/P><\/BLOCKQUOTE>
    \n

    This returns 0. Clearly my transaction isn’t all in there, and the parts that are were rolled back during the restore. Now let’s do the same thing but using NORECOVERY<\/FONT> for the restore of the full backup and also applying the log backup I took:<\/P>
    \n


    \n

    RESTORE<\/FONT><\/FONT> <\/FONT>DATABASE<\/FONT> AdventureWorks <\/FONT>FROM<\/FONT> <\/FONT>DISK<\/FONT>=<\/FONT>‘C:\\SQLskills\\AdventureWorks.bck’ <\/FONT>WITH<\/FONT> <\/FONT>REPLACE<\/FONT>,<\/FONT> <\/FONT>NORECOVERY<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/P><\/FONT>
    \n

    RESTORE<\/FONT><\/FONT> <\/FONT>LOG<\/FONT> AdventureWorks <\/FONT>FROM<\/FONT> <\/FONT>DISK<\/FONT>=<\/FONT>‘C:\\SQLskills\\AdventureWorks_Log.bck’ <\/FONT>WITH<\/FONT> <\/FONT>RECOVERY<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/P><\/FONT>
    \n

    SELECT<\/FONT><\/FONT> <\/FONT>MAX<\/FONT> <\/FONT>(<\/FONT>VacationHours<\/FONT>)<\/FONT> <\/FONT>FROM<\/FONT> AdventureWorks<\/FONT>.<\/FONT>HumanResources<\/FONT>.<\/FONT>Employee<\/FONT>;<\/P><\/FONT><\/FONT>
    \n

    GO<\/P><\/FONT><\/BLOCKQUOTE>
    \n

    This time the SELECT returns 200. And now you can start playng around with fn_dblog<\/FONT> if you didn’t know about it before. I’ll be posting more about Storage Engine internals that you can figure out from the transaction log in future.<\/P><\/FONT><\/FONT><\/FONT><\/FONT><\/p>\n","protected":false},"excerpt":{"rendered":"

    Here’s a really interesting question that was in my search engine logs yesterday – if I have a transaction that runs and completes while a backup is running, will the complete transaction be in the backup? The answer is…. it depends! In terms of what gets backed up, the way a full backup works is: Note […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,38,78,98,100],"tags":[],"class_list":["post-1160","post","type-post","status-publish","format-standard","hentry","category-backuprestore","category-example-scripts","category-search-engine-q-and-a","category-transaction-log","category-undocumented-commands"],"yoast_head":"\nSearch Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup - Paul S. Randal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Here’s a really interesting question that was in my search engine logs yesterday – if I have a transaction that runs and completes while a backup is running, will the complete transaction be in the backup? The answer is…. it depends! In terms of what gets backed up, the way a full backup works is: Note […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2007-10-06T01:00:37+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/\",\"name\":\"Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2007-10-06T01:00:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup - Paul S. Randal","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:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/","og_locale":"en_US","og_type":"article","og_title":"Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup - Paul S. Randal","og_description":"Here’s a really interesting question that was in my search engine logs yesterday – if I have a transaction that runs and completes while a backup is running, will the complete transaction be in the backup? The answer is…. it depends! In terms of what gets backed up, the way a full backup works is: Note […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/","og_site_name":"Paul S. Randal","article_published_time":"2007-10-06T01:00:37+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/","name":"Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2007-10-06T01:00:37+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-6-using-fn_dblog-to-tell-if-a-transaction-is-contained-in-a-backup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=1160"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1160\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=1160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=1160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=1160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}