Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    12

    Unanswered: Log Shipping Error on SQL 2000 SP4

    I'm attempting to configure log shipping on 2 servers with SQL Server 2000 sp4 Enterprise Edition. I keep getting the following error when the job attemtps to execute.

    Error 14261: The specified primary_server_name.primary_database_name('C')
    already exists.

    I have tried this KB http://support.microsoft.com/kb/298743 and i got the same error again!

    Please HELP!

  2. #2
    Join Date
    Jul 2004
    Posts
    12
    any hints ?

  3. #3
    Join Date
    Mar 2005
    Location
    Netherlands
    Posts
    280
    Just a wild guess... Are you logshipping to the same instance or between to SQL instances? If the latter is the case, have you ran the MS solution on both instances? (just to be sure)
    Last edited by Lexiflex; 01-26-07 at 15:35.

  4. #4
    Join Date
    Dec 2010
    Posts
    1

    Clean up all instances

    Old post - Resolution nevertheless - Run cleanup sp's on each SQL server instance before re-opening maintenance plan wizard.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •