SQL Server – Log Shipping Option Not Showing

log-shippingsql serversql-server-2008-r2

I am using SQL Server 2008 R2 Standard Edition. I am trying to implement log shipping, but the log shipping option is not showing in the database properties window. The database recovery option is bulk logged.

enter image description here

Best Answer

Shyamev,

Just to make sure the database selected should be a user and not any system databases.

But in many cases we have seen this even if its user database is selected and the option of log shipping is missing.

Solution: Re-install SSMS with the Management Tools - Complete option checked.

Refer to below link:

https://social.msdn.microsoft.com/forums/sqlserver/en-US/01a0ab24-5555-4b55-b399-a866a5b09d1d/transaction-log-shipping-option-is-missing

Related Question