sql server replication: Is it true that log shipping is only for a readonly secondary server?

Thanks,
Gus

Hi

The data, in the specific DB, on the 2nd server can not be written to.

With log shipping, you can set it up in 2 ways and the restore command has 2
options:

NORECOVERY is used to restore a DB and logs, but not allow access the
restored DB (for continuous log shipping)

STANDBY allows a database to be brought up for read-only access between
transaction log restores and can be used with either warm standby server
situations or special recovery situations in which it is useful to inspect
the database between log restores.


For DR purposes, at work, we use NORECOVERY as it is truly A DR server that
we are shipping to.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]