Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

automatic page restore from backup

Add a database level option that if FULL recovery model is selected and suspect pages are pickup up by SQL server, the engine should automatically attempt to restore the page from the last available backup if the backup is less than 24 hours old and a full log chain exists.

2 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Adrian Sullivan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base