Timeline for How to recover deleted rows data table in SQL Server without backup? [duplicate]
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 7, 2021 at 15:49 | history | closed |
John K. N. mustaccio nbk McNets Vérace |
Duplicate of How do I get back some deleted records? | |
| Mar 3, 2021 at 12:10 | review | Close votes | |||
| Mar 7, 2021 at 15:49 | |||||
| Jul 16, 2020 at 0:30 | comment | added | Aaron Bertrand | dba.stackexchange.com/questions/995/… | |
| Jul 16, 2020 at 0:23 | comment | added | Kevin Turnip | sorry, I don't really know about that. I also thought it would be easy with a backup file, apparently I was wrong because the file last week was not in backup. | |
| Jul 16, 2020 at 0:20 | answer | added | Paul W | timeline score: 2 | |
| Jul 16, 2020 at 0:18 | history | migrated | from stackoverflow.com (revisions) | ||
| Jul 16, 2020 at 0:17 | comment | added | Bohemian | If you have all the logs between the last backup and now you can restore the database the point in time and probably recover the data, but it's surgery and you must take the database offline. | |
| Jul 16, 2020 at 0:12 | comment | added | SS_DBA |
But unfortunately, the last backup of the database was done last week. So your company accepts 1 weeks worth of data loss? What about Differential or Transaction Log backups? Do you replicate to a DR server? What's your DR plan? What is the maintenance plan on the database?
|
|
| Jul 16, 2020 at 0:07 | history | asked | Kevin Turnip | CC BY-SA 4.0 |