January 31, 2011 at 11:37 pm
Hi All,
We are implementing the logshipping mechanism for reporting purpose on secondary databases ...
if any error occurs, while restoring the t-log to the secondary server ...will there be any chances of secondary database getting corrupted?
February 1, 2011 at 6:02 am
It depends. We can't say for sure.
Eg. Restore job may fail due to some space issue. In that case, restore may not have happened regularly but the problem can be fixed on reclaiming\adding space.
In this case, the secondary db would be just out of sync with primary and once the restore job is fixed the db may come back to normal.
M&M
February 1, 2011 at 6:14 am
Thnks moin.Good piece of info. Boj:)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply