RV-813525 (4/6/2010)
At the end of day I have to ship the logs from each of the client's database and sync to the centralized database.
Log shipping does not work like this. Log shipping from multiple primary servers to single secondary server is not allowed. Opposite of it possible. You can have single primary server and multiple secondary servers.
What is need is replication.