As we bring back online our Log Shipping DR SQL Instance, wanted to write a couple of scripts to review the settings and put in place ongoing monitoring.
select [serverPrimary] = cast(serverproperty('servername') as sysname) , [database] = tblLSP.primary_database , [directoryBackupLocal] = tblLSP.backup_directory , [directoryBackupNetworkShare] = tblLSP.backup_share , tblLSP.last_backup_file , tblLSP.last_backup_date from [msdb].[dbo].[log_shipping_primary_databases] tblLSP
select [serverSecondary] = cast(serverproperty('servername') as sysname) , [database] = tblLSS.[secondary_database] , tblLSS.last_restored_file , tblLSS.last_restored_date , tblLSS.restore_delay , tblLSS.disconnect_users from [msdb].[dbo].[log_shipping_secondary_databases] tblLSS
Listening and dedicating Joshua Radin’s Everything’ll Be Alright (Will’s Lullaby) to a new and special friend who is moving to Columbia.
It is always good to meet someone that still believes in a World without barbwires.
God’s Speed as she follows Camelot’s calling.