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
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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: