As per them restore job was failing with errors. Let us learn how to solve Log Shipping Job Error: Failed to Connect to Server.
SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform this Operation – 2
Many disaster recovery solutions are available in SQL Server. Let’s learn how we can fix a specific log shipping error about the sysadmin fixed server role.
SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform This Operation
They have observed that Log Shipping Copy and Log Shipping Restore jobs have been failing with log shipping error. Let us fix them.
What are Ports Needed to Configure Log Shipping? – Interview Question of the Week #169
What are ports needed to configure log shipping? A client in a locked-down network asked me, and here is the list of ports to open on the firewall.
SQL SERVER – Log Shipping Monitor Not Getting Updated
The log shipping monitor stopped updating last_backup_file and last_backup_date for the primary, while every job ran fine. Here is how I traced it.
SQL SERVER – Msg 32055 – sp_refresh_log_shipping_monitor – There Was an Error Configuring the Remote Monitor Server
Msg 32055, error configuring the remote monitor server, hides the real error. Read from the procedure on SQL Server 2025, with a safer fix than sa.
Log Shipping Alternative for Databases in Simple Recovery Model
A log shipping alternative for a database in the simple recovery model is a second copy that restores the newest full backup and the newest differential backup. This post finds those two files from the backup history in msdb, restores them with MOVE and RECOVERY, and repeats the cycle on a schedule. It also states what you lose compared with real log shipping.