<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <Body>
    <ReportItems>
      <Textbox Name="Textbox1">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>
--To Copy the code, right click and export to Word

--Foundation Code Source: https://www.mssqltips.com/sqlservertip/1601/script-to-retrieve-sql-server-database-backup-history-and-no-backups/
   SELECT 
   msdb.dbo.backupset.database_name, 
   CASE WHEN d.recovery_model = 3 THEN 'SIMPLE'
	WHEN d.recovery_model = 1 THEN 'FULL'
	WHEN d.recovery_model = 2 THEN 'BULK LOGGED' END AS 'RecoverModel',
	CASE WHEN d.state = 0 THEN 'Online' END AS 'State',
   CONVERT(VARCHAR(100),MAX(msdb.dbo.backupset.backup_finish_date)) AS last_db_backup_date, 
   CONVERT(VARCHAR(100),DATEDIFF(hh, MAX(msdb.dbo.backupset.backup_finish_date), GETDATE())) AS [Backup Age (Hours)] ,
CASE WHEN msdb.dbo.backupset.type = 'D' THEN 'Full'
WHEN msdb.dbo.backupset.type = 'L' THEN 'Transaction Log' END AS 'Type'
FROM    msdb.dbo.backupset  Right outer JOIN
master.sys.databases d
on d.name = msdb.dbo.backupset.database_name
WHERE     msdb.dbo.backupset.type IN ('L')  AND
d.Recovery_Model IN (1) AND d.state = 0 AND d.name NOT IN ('Distribution', 'Tempdb')
GROUP BY msdb.dbo.backupset.database_name , msdb.dbo.backupset.type,d.recovery_model, d.state
HAVING      (MAX(msdb.dbo.backupset.backup_finish_date) &lt; DATEADD(hh, - 24, GETDATE())) 
UNION
   SELECT 
   msdb.dbo.backupset.database_name, 
   CASE WHEN d.recovery_model = 3 THEN 'SIMPLE'
	WHEN d.recovery_model = 1 THEN 'FULL'
	WHEN d.recovery_model = 2 THEN 'BULK LOGGED' END AS 'RecoverModel',
	CASE WHEN d.state = 0 THEN 'Online' END AS 'State',
   CONVERT(VARCHAR(100),MAX(msdb.dbo.backupset.backup_finish_date)) AS last_db_backup_date, 
   CONVERT(VARCHAR(100),DATEDIFF(hh, MAX(msdb.dbo.backupset.backup_finish_date), GETDATE())) AS [Backup Age (Hours)] ,
CASE WHEN msdb.dbo.backupset.type = 'D' THEN 'Full'
WHEN msdb.dbo.backupset.type = 'L' THEN 'Transaction Log' END AS 'Type'
FROM    msdb.dbo.backupset  Right outer JOIN
master.sys.databases d
on d.name = msdb.dbo.backupset.database_name
WHERE     msdb.dbo.backupset.type IN ('D')  AND
d.Recovery_Model IN (1,3) AND d.state = 0 AND d.name NOT IN ('Distribution', 'Tempdb')
GROUP BY msdb.dbo.backupset.database_name , msdb.dbo.backupset.type,d.recovery_model, d.state
HAVING      (MAX(msdb.dbo.backupset.backup_finish_date) &lt; DATEADD(hh, - 24, GETDATE()))  

UNION

   SELECT 
   d.name, 
   CASE WHEN d.recovery_model = 3 THEN 'SIMPLE'
	WHEN d.recovery_model = 1 THEN 'FULL'
	WHEN d.recovery_model = 2 THEN 'BULK LOGGED' END AS 'RecoverModel',
	CASE WHEN d.state = 0 THEN 'Online' END,
   'Missing' AS last_db_backup_date, 
   'Missing' AS [Backup Age (Hours)] ,
'Missing' AS 'Type'
FROM    msdb.dbo.backupset  RIGHT OUTER JOIN
master.sys.databases d
on d.name = msdb.dbo.backupset.database_name
WHERE     
msdb.dbo.backupset.type IS NULL and d.state = 0 AND d.name NOT IN ('Distribution', 'Tempdb')
GROUP BY d.name , msdb.dbo.backupset.type,d.recovery_model, d.state
</Value>
                <Style>
                  <FontSize>14pt</FontSize>
                </Style>
              </TextRun>
            </TextRuns>
            <Style />
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox1</rd:DefaultName>
        <Top>1.50593in</Top>
        <Left>0.26333in</Left>
        <Height>14.12685in</Height>
        <Width>9.22in</Width>
        <Style>
          <Border>
            <Style>Solid</Style>
          </Border>
          <BackgroundColor>LightBlue</BackgroundColor>
          <PaddingLeft>8pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox2">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Missing Backup Code</Value>
                <Style>
                  <FontSize>18pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox2</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MainReport</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>0.14667in</Top>
        <Left>0.26333in</Left>
        <Height>0.45in</Height>
        <Width>9.22in</Width>
        <ZIndex>1</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>DarkBlue</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox4">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Go to Main Report</Value>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox3</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>=IIF(First(Fields!ProductMajorVersion.Value, "Version") = 10 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "MainReport2008", 
IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, 
IIF(First(Fields!ProductMajorVersion.Value, "Version") &gt; 10 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "MainReport", Nothing)))</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>0.64991in</Top>
        <Left>0.26333in</Left>
        <Height>0.36667in</Height>
        <Width>9.22in</Width>
        <ZIndex>2</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>DimGray</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox8">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Go to Report Library</Value>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox5</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>ReportLibrary</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>1.06982in</Top>
        <Left>0.26333in</Left>
        <Height>0.36667in</Height>
        <Width>4.5347in</Width>
        <ZIndex>3</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>DimGray</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox9">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Back to the Report</Value>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox6</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MissingBackups</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>1.06982in</Top>
        <Left>4.86747in</Left>
        <Height>0.36667in</Height>
        <Width>4.61586in</Width>
        <ZIndex>4</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>DimGray</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
    </ReportItems>
    <Height>16.43001in</Height>
    <Style>
      <BackgroundColor>Silver</BackgroundColor>
    </Style>
  </Body>
  <Width>9.75833in</Width>
  <Page>
    <PageHeight>96in</PageHeight>
    <LeftMargin>1in</LeftMargin>
    <RightMargin>1in</RightMargin>
    <TopMargin>1in</TopMargin>
    <BottomMargin>1in</BottomMargin>
    <Style />
  </Page>
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="Local">
      <ConnectionProperties>
        <DataProvider>SQL</DataProvider>
        <ConnectString>Data Source=localhost;Initial Catalog=master</ConnectString>
        <IntegratedSecurity>true</IntegratedSecurity>
      </ConnectionProperties>
      <rd:SecurityType>Integrated</rd:SecurityType>
      <rd:DataSourceID>dc99daea-2fbc-47fe-99de-e66afcee2c14</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="Version">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>SELECT  SERVERPROPERTY('ProductMajorversion') AS 'ProductMajorVersion'</CommandText>
      </Query>
      <Fields>
        <Field Name="ProductMajorVersion">
          <DataField>ProductMajorVersion</DataField>
          <rd:TypeName>System.Object</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="ServerProperty">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>SELECT ServerProperty('EngineEdition') AS 'EngineEdition'</CommandText>
      </Query>
      <Fields>
        <Field Name="EngineEdition">
          <DataField>EngineEdition</DataField>
          <rd:TypeName>System.Object</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>1015913d-fc97-4dcd-8009-eea036220b24</rd:ReportID>
</Report>