-1

I have Damaged a page in my database and now I want to restore it

let me get this straight

1- I created a full backup

2- then insert info in some tables

3- creat a deferential backup

4- specific a page from a certain table to damage it

5-now I want to know is it possible to restore the page?

I know that to restore a page it requires a full backup

but my full backup doesn't contain the page only the deferential backup

3
  • Didn’t you ask how to intentionally damage your database just two days ago? If the goal is to learn how to handle disk failure or other “middle-of-the-night scenarios”, perhaps a little more clarity would help others understand the objective and point you in the right direction to learn these skills in a more thorough manner – matigo Jun 6 at 23:00
  • Yes exactly let me get this straight 1- I created a full backup 2- then insert info in some tables 3- creat a deferential backup 4- specific a page from a certain table to damage it 5-now I want to know is it possible to restore the page? I know there to restore a page require a full backup – michele Jun 6 at 23:12
  • Do you have a procedure you're working from, and have questions? Are you getting stuck or having trouble part way through? Or are you just having trouble with even getting started? – AMtwo Jun 7 at 0:07
0

Since we don't seem to have a specific situation at hand, I suggest you start by reading the documentation about page restore. That should answer most of your question.

One thing that you need is log backups.

Whether you can restore a page from a diff backup (instead of the earlier full backup) depends on whether that differential backup contains the page, quite simply.

Documentation: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-pages-sql-server?view=sql-server-ver15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.