Home / server / Questions / 361671
In Process
Tim Long
Asked: 2012-02-20 12:25:06 +0800 CST

How to Configure SQL Server 2008 R2 Log Shipping

  • 772

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?

sql-server database configuration log-shipping sql-server-2008-r2

1 Answers

  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.

    • 3