Script:
select @@servername
select getdate()
go
Current date
Get last full, differential backup
--Last Full and Differential Backup files
/sqldbbackup/differential_backup/dbname_20230131.bak2
/sqldbbackup/full_db_backup_monthly/dbname_2023_01_27_07_00_02.bak
Get log files after last differential backup finish datetime
--Latest differential backup finish timeframe
backup_finish_date
-----------------------
2023-01-31 05:00:01.000
--Log files after latest differential Backup
/sqldbbackup/tlog_backup/dbname_2023_01_31_05_05_00_.trn
/sqldbbackup/tlog_backup/dbname_2023_01_31_05_00_01_.trn
Copy the backup file to test server
Restore full backup followed by differential and log backup & Check database status
If issue with certificate then restore certificate on linux db server and restore
---Cannot find server certificate with thumbprint '0xBABE56F27EEA5D07E62E684AA4A1C9E876DD509D'.
---Msg 3013, Level 16, State 1, Line 19
---VERIFY DATABASE is terminating abnormally.
--Linux
CREATE CERTIFICATE BackupCertificate
FROM FILE = N'/sqldbbackup/certs/BackupCertificate.cer'
WITH PRIVATE KEY (
FILE = N'/sqldbbackup/certs/BackupCertificate.key',
DECRYPTION BY PASSWORD = 'PasswordToDecrypt');
GO
