Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need to set up a standby server using SQL Server Log Shipping. This is my first time doing this, so I'm following the instructions in the SQL Help step by step. Of course, I ran into a problem at the first step. The help file says:

  1. Right click the database you want to use as your primary database in the log shipping configuration, and then click Properties.
  2. Under Select a page, click Transaction Log Shipping.

I do not see a menu entry for Transaction Log Shipping. Here's what I see:
Database Properties

So why am I not being offered this option?

share|improve this question

1 Answer 1

In order to see the "Transaction Log Shipping" option in SQL Server Management Studio, you have to have the complete management tools option select. Try to re-install management studio, and check the box for "Management Tools - Basic" and the box for "Management Tools - Complete"

enter image description here

Also, you can't log ship a database that has an ID of 1 - 4 since SQL Server assumes that it's either master, model, msdb or tempDB.

share|improve this answer
    
Thanks, that's all good information. I presume this 'complete install' has to be on the management station (which is remote)? –  Tim Long Feb 20 '12 at 16:21
    
Yes, it has to be on whichever machine you are trying to enable log shipping on the server from. Not the server itself. –  Wesley Feb 20 '12 at 17:24
    
Excellent, thanks for the advice. Of course, I don't have the installation media handy so will need to download a fresh copy tomorrow. –  Tim Long Feb 21 '12 at 1:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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