sql server replication: I have a SQL server with 90 databases (with avg of 30
tables in each) , each needs to be replicated (Transaction
immediate)
The Distrubution databse is on this server. I have been
having problems with some of the database failing to
replicate, and I was wondering if Log shipping between
linked servers would be a better option.

The 2 methods are similar but not exactly equivalent -
please look at the article on www.replicationanswers.com
where I have contrasted most functionality to help make
the decision easier.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Log shipping replicates the entire database. Replication will allow you to
replicate a subset of the database, allow you to subset the data, but will
not replicate system objects.

While using log shipping your users will have to go offline while the logs
are being applied, and the database must be treated as read only. You cannot
place custom indexes on the subscriber or modify the schema there.

--
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html

[quoted text, click to view]