Tag Archives: sql server LOG Shipping

How to Monitor SQL Server Log Shipping?

LOG Shipping can be monitored SQL Server Management Studio or via TSQL Queries Prior to Monitor, let’s take a quick look a Log Shipping Scenario which we wanted to monitor Primary Server Details SQL Server Name .\SQL1 Database Name TEST_LOG_Shipping Secondary Server Details, where we are shipping Logs SQL Server Name .\SQL2 Database Name TEST_LOG_Shipping [...]

LOG Shipping using SQL Server 2008

Log shipping technology is one of the methods for implementing High Availability solution. Log shipping is easy to set up,  standby database can be available for reporting purpose, easy to maintain and troubleshoot, and multiple standby databases can be configured for log shipping in the same server or instance.  One of the main issues or [...]