HI , take my advise if you like then follow this

even your posting create so much of confusion after reading so many times i am giving reply first read the reply and in the end follow the logic at the end of this post.....

First of all you chill out take a T&D server [or] in your laptop configure the log-shipping primary and secondary databases coz Not to mess up your brain with production server until u are trying to work out these modifications in production server you always feel frustrated every time your attempt fails

1. if i'am correct you have a production servers " 1 & 2 " with database name [Test Database ] you added couple of tables backed up and restored it to secondary server (Server 2 database) selecting the RESTORE WITH STANDBY option in order to get it created there also checked properly sync of both 1&2 server database in which SQL Server log-shipping is been configured and running fine.

up to tz fine

2.whether you removed the server 2 database from the log-shipping and added server 3 database in log-shipping ?????????????? make sure it happened properly

-----[1] do u want server 1 database

server 2 database

server 3 database

All in log-shipping as primary , secondary ,and monitor give clarity in this ????????????? if u want to configure like this ....

if not ok and see below ----------------------------------------------

----- from here

[2] if u want to add server 3 to server 1 in log-shipping

configuration

"" whether you removed ?? server 2 database from secondary

database in log-shipping after removing server 2 database only you have added server 3 database as secondary database to log-shipping make sure

in this.. then you get clarity """

3. if you have removed server 2 database and added server 3 database as secondary database in the log-shipping configuration,after adding then you created couple of tables in server 1 database , and

-------- [1] you have run the ls_backup job in server 1 database

[2] you have run the ls_copy and ls_restore jobs in new

secondary database server 3 database.

Even though the changes which you made in server 1 database are not applying in the sever 3 database [ new secondary ]...

follow this

" before u removing server 2 database and adding server 3 database "

1. http://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/

2. at removing secondary database server 2 database and click ok in log - shipping configuration wizard [ right click on data base --> task--> log-shipping ]

then again go to the server 1 database [ right click on data base --> task--> log-shipping ] add server 3 database as secondary database then your log-shipping primary and secondary will ready and make any changes in the server 1 database and run ls_backup job in server 1 database and run ls_copy , ls_restore jobs in server 3 database .then both servers will be in synchronization

-------------------------------------------

logic :---- for ur requirement simply. don't confuse here ...

-------------------------------------------

three servers 1,2,3 database

----[1] server 1 database ----->server 2 database in log-shipping you made changes in 1 and checked in 2 whether it is applying or not yes it is applying

----[2] you want to remove server 2 [database ]from log-shipping and add make changes in server 1 database and then configure log-shipping to server 1 database [to ]server 3 database then both will be in synchronization.

if every thing i working fine in T&D [or ] in ur laptop then go in to the production server ....