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 advanceDIsable the LS and apply full backup on secondary server, then enable LS again.sql
No comments:
Post a Comment