sql server replication: Hi Folks,
I was wondering if a Read Only Database can also be a publisher. Keep in
mind that this Read Only Database is a standby server for Log Shipping.
Thanks.

Patrick
replication will add some system tables and in some cases (merge and immed-upd-trans) add a column to the publishing database. Because of this it can't be read only. Also in the case of log-shipping, the destination (standby) database must be used with care because an exclusive lock is required to restore each log. Being in the databse when the log is applied will caues it to error, but this applies to using the standby databse for reporting purposes
Regards

Not much you can do with a STANDBY DB except for SELECT. Since backup
is not possible, PUBLICATION is not possible. If you have needs for
multiple replications because of business needs (reporting etc.) have
the primary server publish to two different locations. If your user is
keep breaking the synch because they log on to the Standby DB, have
them logon to a different DB (northwind, model etc) and run query from
there preventing permanent residency on the STANDBY DB. Or if its not
large you can do SELECT INTO to where ever you want. Just a
suggestion.

[quoted text, click to view]