Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Add support for adding a delay to log restores #71

Closed
DavidWiseman opened this issue Mar 27, 2024 · 0 comments
Closed

Add support for adding a delay to log restores #71

DavidWiseman opened this issue Mar 27, 2024 · 0 comments

Comments

@DavidWiseman
Copy link
Collaborator

This is a feature supported by native log shipping. We might want to restore to a point in time before a bad transaction was committed to the database. If the logs are applied to the secondary server immediately this might not provide sufficient delay. By introducing an artificial delay we can guarantee we have a set amount of time available to be able to recover from application or user errors.

image
DavidWiseman added a commit to DavidWiseman/sql-log-shipping-service that referenced this issue Mar 27, 2024
@DavidWiseman
Add RestoreDelayMins config option
77a5f4c 
Add the option of a delay to guarantee a set amount of time will be available to recover from application or user errors.
trimble-oss#71
@DavidWiseman DavidWiseman mentioned this issue Mar 27, 2024
Merged
DavidWiseman added a commit that referenced this issue Mar 27, 2024
@DavidWiseman
Add RestoreDelayMins config option
2902548 
Add the option of a delay to guarantee a set amount of time will be available to recover from application or user errors.
#71
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@DavidWiseman