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/
"Gus" <noreply@.noreply.com> wrote in message
news:#BNSbRRHFHA.2752@.TK2MSFTNGP12.phx.gbl...
> Is it true that log shipping is only for a readonly secondary server?
> Thanks,
> Gus
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment