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

login to online sql database

Hi all; I am trying to login to an online sql database from enterprise manager;

First of all is this possible and second of all, how do I go about doing it from enterprise manager (by the way I am using MS SQL 2000)

THanks for any assistance

It *may* be possible, depending on how the remote SQL Server is set up,(I.E., if it's got the TCP/IP network library enabled) and if there areno firewalls blocking communication between you and it.
If you can connect to it, it's just a matter of right-clicking on oneof your SQL Server group nodes in the tree, and selecting "New SQLServer Registration". Then, give the wizard the IP address or URLto your remote SQL Server, follow the rest of the wizard's steps, andyou're connected.