SQL Server Performance

Log shipping is not installed on this instance

Discussion in 'SQL Server 2005 Log Shipping' started by fprefect, Jun 16, 2008.

  1. fprefect New Member

    Hello. I am getting the followin error while trying to set up Log Shipping in SQL 2005 Standard Edition. Please note that I can set it up on the other two instances on this box.
    Log shipping is not installed on this instance. (Microsoft SQL Server, Error: 32018)
    Any help you can provide on this would be greatly appreciated.
    fprefect, Jun 16, 2008
    #2

  2. ghemant Moderator

    Hi,
    Does your environment meet all pre-requisite for Log shipping!!
    ghemant, Jun 16, 2008
    #3

  3. fprefect New Member

    Hi,
    Yes it does.
    fprefect, Jun 17, 2008
    #4

  4. ghemant Moderator

    ghemant, Jun 18, 2008
    #5

  5. satya Moderator

    Log shipping is not a program or utility to install within SQL 2005, in its most simple terms, it is the backup of a database's log files on one server and applying them to another server. If you are using 2005, here is a good link on how to set it up: http://msdn.microsoft.com/en-us/library/ms188698.aspx.
    Can you explain how you are trying to enable it (steps)?
    satya, Jun 18, 2008
    #6

  6. fprefect New Member

    I have tried two ways of setting it up, both through SQL Management Studio.
    The first one is to simply right click on the source database and then click Tasks and then Ship Transaction Logs. After I click that I get the error I mentioned previously.
    The second method is to right click on the source database and then choose Properties. On the Properties screen, I select Transaction Log Shipping. After I click that, I get the error.
    Thanks
    fprefect, Jun 18, 2008
    #7

Share This Page