June 2, 2009 at 6:01 am
Hi Team,
i have small dought on logshipping
suppose my primary server fail or down how to recover up to point of
failure.
Thnaks
Ramakrishna
June 2, 2009 at 6:39 am
Well you can restore until the last point where you have backed up a transaction log, you have to restore the last log then change the database mode and required server changes like server name and ip address as per you r requirements 🙂
June 2, 2009 at 7:02 am
If the failure occurs on the primary server then the recovery process is exactly as would be required in order to recover a database that is not being log shipped.
The secondary server/database (being log shipped to) cannot be used to recover the primary database upto the point of failure as the most recent transactions at the primary will still be within the active portion of the transaction log file and will not yet have been shipped to the seconday server.
June 2, 2009 at 12:17 pm
In addition you can attempt to recover the remaining transaction log entries and apply them to the log shipping backup after the other log backups have been applied.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply