QL Database Admin | AWS Cloud | PowerShell Automation | Performance Tuning | Disaster Recovery
Log Shipping Information from Primary and Secondary Log Shipping server
SET NOEXEC OFF DECLARE @primaryORsecondaryserver varchar(100); DECLARE @PrimaryServerBackupType varchar(100); DECLARE @SecondaryServerCopyType varchar(100); SET @primaryORsecondaryserver = (SELECT top 1 agent_type from [msdb].[dbo].[log_shipping_monitor_history_detail]) SET @PrimaryServerBackupType = ‘0’ SET @SecondaryServerCopyType = ‘1’ IF (@primaryORsecondaryserver = @PrimaryServerBackupType ) BEGIN SELECT MP.[primary_server] as [Primary Server] ,MP.[primary_database] ,PB.[backup_directory] ,PB.[backup_share] ,MP.[last_backup_file] ,PB.[backup_retention_period] ,MP.[backup_threshold] ,MP.[last_backup_date] FROM [msdb].[dbo].[log_shipping_monitor_primary] AS MP JOIN [msdb].[dbo].[log_shipping_primary_databases] AS PB […]
The Easiest Way to Become a Successful Writer and Authors.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle […]
The Quickest Way to Deliver Your Message? Make It Visual.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle […]
Why We Don’t Have Technical Interviews for Technical Roles at Buffer.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle […]
Why Successful People Wear The Same Thing Every Day.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle […]
What I Learned From Being a Broke, Unemployed Graduate.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle […]