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
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
Question: What are Ports Needed to Configure Log Shipping?
SQL SERVER – Log Shipping Monitor Not Getting Updated
One of my clients has implemented log shipping and everything was working fine. Recently they implemented a reporting tool which reported alerts that data missing for few log shipping tables. The data for “last_backup_file” and “last_backup_date” is not getting updated for primary server (log_shipping_monitor_primary) and was showing null. For secondary it was reported correctly.
SQL SERVER – Msg 32055 – sp_refresh_log_shipping_monitor – There Was an Error Configuring the Remote Monitor Server
Since I started consulting, I never had “Monday Blues” because I don’t get any weekends. I am always ready to help without time boundaries. Consulting gives me exposure to the real customer issue, learn more and blog more. This also helps me to see what customers are implementing rather than what Microsoft has provided as features. This blog is an outcome of a consulting where everything was deployed successfully, but project sign-off was pending due to an issue with log-shipping monitoring. In this blog we would learn about fixing error There was an error configuring the remote monitor server.
SQL SERVER – Alternative of Log Shipping in Simple Recovery Model
The blog topic might seem controversial and doesn’t go well with definition of log shipping features. Read it again. The blog has an alternative way to set up something “similar” to log-shipping. If the database is in simple recovery model, then we can’t take transaction log backups and hence no log shipping possible.