2

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?

1 Answer 1

3

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.

3
  • 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, 2012 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, 2012 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, 2012 at 1:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .