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.