QL Database Admin | AWS Cloud | PowerShell Automation | Performance Tuning | Disaster Recovery
Articles By This Author
SQL Server Backup History Report
Column DescriptionDatabase Name Name of the database being backed up.Backup Start / Backup Finished Start and end timestamps of the backup process.Duration (Minutes) Total time taken to complete the backup (in minutes).Backup File Physical file path of the backup file stored on disk.First LSN / Last LSN Log Sequence Numbers used to track backup chains […]
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 […]
Titile
To make the name and email fields required in Contact Form 7, you’re already using the correct syntax with the * asterisk symbol. This symbol (*) after the field type (like text* or email*) means the field is required. Your current code is already correct, but here’s a cleaner version for clarity and implementation: htmlCopy […]
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 […]