SQL Server Performance

Log shipping can't be ship to secondary database

Discussion in 'SQL Server 2005 Log Shipping' started by Axlin, Jun 24, 2007.

  1. Axlin New Member

    Hi.
    i'm trying to log ship our production database to our development server.
    We are using SQL Server 2005 workgrp edition with Service PAck 2 for both servers.

    After configuring log shipping on the primary database,i realised only the transaction log was backup on the primary database server folder but it did not managed to ship to the secondary database.

    Any idea how do i allow the secondary database to access the primary database folder and vice versa?

    I've already allowed SQL Agent on both servers to have access to their respective folders on their own server by adding them in the folder.

    Even the drives and folders have been shared out n a network path has been created eg:\SERVERBackup but still i can't get the primary database to ship across the logs to our development server.

    Both production and development servers are on a work group level only,not domain.

    I hope there will be links and advices to fix this predicament i'm in.
    Many thanks in advance.
  2. satya Moderator

    Any errors or warnings from event viewer?
    KBAhttp://support.microsoft.com/kb/321247 fyi and check whether you have performed list as same.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. Axlin New Member

    Hi Satya.
    The url you gave is really very helpful.
    Thank you!
  4. satya Moderator

    Are you able to resolve the issue with that, if so post brief feedback that could help others.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page