Guys,

I am bascially new to sql and log shipping. I noticed when I added a
table to my source database, the destination doesn't synchronize.

Does it only synchronized transations only? For example, when I added
a record in the table, it works fine.

So what is the best practice if somebody were to make change to the
database by adding new tables, views, stored procedures? Do I have to
recreate my Log Shipping?


Thanks,
Tony

Tony,
sorry to ask this, but have you really set up log shipping? It sounds more
like you have a publication, in which case it is quite normal that a new
table won't get picked up unless added as an article. In log shipping, the
entire transaction log is transmitted, so any change to the database is
reproduced.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)