Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    24

    Unhappy Unanswered: Logshipping Help Needed

    I am setting up log shipping between a primary server and two secondaries.

    The first (secondary ) is applying the logs fine but the second is generating the following error.

    [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3154: [Microsoft][ODBC SQL Server Driver][SQL Server]The backup set holds a backup of a database other than the existing 'CDE2' database.
    [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.

    the logshipping monitor says it failes to apply first_file_0000000000...Trn

    I have seen this listed on MS KB Base Article - 311801 .

    and have followed all the suggestions to resolve this issue including seperate folders for each log ship but to no avail.

    Any help would be greatly appreciated.

    Thanks in advance
    TECMAN

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    DIsable the LS and apply full backup on secondary server, then enable LS again.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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