2

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

  • Can you post a screenshot of the "Database Properties" window? – Thomas Stringer Oct 16 '14 at 11:26
  • In the properties window the last page select is extended properties. And i dont know how to insert a image in the comment it look like only text is accepting – Shyam Prasad Oct 16 '14 at 11:34
  • You can insert an image into the body of your question (just hit the "edit" button). – Thomas Stringer Oct 16 '14 at 11:46
  • Do you have proper permissions? – Kin Shah Oct 16 '14 at 12:29
  • which permission do you mean? #kin – Shyam Prasad Oct 17 '14 at 4:47
0

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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.