In
Log shipping by default the secondary database will not come online
automatically if the primary database becomes un-available.During log shipping,
the secondary database will be in Standby or No Recovery mode that means it
will be available for Read-Only.
In order to bring
the secondary database involved in log shipping to online we have to use any of
below commands. These command are to be used in case the primary database
becomes un-available either because of database corruption or database going
offline or any other damage to the primary database.
Restore Database <Database Name>
WITH Recovery
(or)
Restore Log <Database
Name> WITH Recovery
Thanks!!!
No comments:
Post a Comment