Simplified Disaster Recovery never detects HPE Ultrium 45000 LTO-9.

Problem

Simplified Disaster Recovery (SDR), which is created from Backup Exec 21.4 and ADK 2022, never detects HPE Ultrium 45000 LTO-9. This issue is confirmed on Backup Exec 21.4 or 22 that is upgraded from Backup Exec 21.4.
The issue never happens on Backup Exec 22 that is fresh-installed.
 

Error Message

N/A
 

Solution

This issue has been resolved in Backup Exec 22.1.
After the upgrade to Backup Exec 22.1, back up and create a new SDR media.
The SDR, which is created from Backup Exec 22.1 and ADK 2022, successfully detects the HPE Ultrium 45000 LTO-9.
 

Workaround:

In case of Backup Exec 21.4 or 22 that is upgraded, the issue is resolved with the below steps.

1. Copy & paste the below all lines to Notepad, and save as LTO9_MediaType_Fix.txt.

--------------------------------------------------------------------------------------------------
--
--  Copyright (c) 2023 Veritas Technologies LLC. All Rights Reserved
--
--------------------------------------------------------------------------------------------------
print 'LTO9_MediaType_Fix.sql starts ' + convert(nvarchar, getdate())
GO

----------------------------------------------------------------------------------------------------
-- Update the MediaType to 8(LTO) for LTO 9 devices for vendor IBM, HPE and QUANTUM
IF EXISTS( select * from Device where ( DeviceprimaryInquiry like 'HPE     ULTRIUM 9%'   OR DeviceprimaryInquiry like 'IBM     ULTRIUM-TD9%' OR
                                        DeviceprimaryInquiry like 'IBM     ULTRIUM-HH9%' OR DeviceprimaryInquiry like 'IBM     ULT3580-TD9%' OR
                                        DeviceprimaryInquiry like 'IBM     ULT3580-HH9%' OR DeviceprimaryInquiry like 'QUANTUM ULTRIUM-HH9%' ) AND MediaType = 0 AND DeviceType = 2) 
    BEGIN  
        update Device SET Mediatype = 8
        where ( 
                DeviceprimaryInquiry like 'HPE     ULTRIUM 9%' OR
                DeviceprimaryInquiry like 'IBM     ULTRIUM-TD9%' OR
                DeviceprimaryInquiry like 'IBM     ULTRIUM-HH9%' OR
                DeviceprimaryInquiry like 'IBM     ULT3580-TD9%' OR
                DeviceprimaryInquiry like 'IBM     ULT3580-HH9%' OR 
                DeviceprimaryInquiry like 'QUANTUM ULTRIUM-HH9%') AND MediaType = 0  AND DeviceType = 2
    END
GO

print 'LTO9_MediaType_Fix.sql ends ' + convert(nvarchar, getdate())
GO

--------------------------------------------------------------------------------------------------

2. Rename LTO9_MediaType_Fix.txt to LTO9_MediaType_Fix.sql.

3. Logon as Backup Exec Administrator on Backup Exec server, and copy LTO9_MediaType_Fix.sql to the Backup Exec server.

4. Launch Command Prompt.

5. Move to the folder where LTO9_MediaType_Fix.sql is copied.
    If LTO9_MediaType_Fix.sql is copied to C:\sql folder, run the below command.

   cd c:\sql

6. Run the below command, and  

   sqlcmd -E -S .\bkupexec -d BEDB -i LTO9_MediaType_Fix.sql

7. The below outputs will appear when the above command is successful.

      LTO9_MediaType_Fix.sql starts Mar 9 2023 3:30PM
      LTO9_MediaType_Fix.sql ends Mar 9 2023 3:30PM

8. Back up and create a SDR media.

9. Boot from the SDR media. LTO9 will be detected successfully.