Timeline for Restore filegroup without log sequence number (LSN)
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 11, 2022 at 15:06 | answer | added | Tibor Karaszi | timeline score: 2 | |
| Apr 11, 2022 at 1:05 | comment | added | Charlieface |
If you don't have the relevant log backup files, you could potentially restore using STOPATMARK = 'lsn:5470633.... to stop at a point which you do have. Obviously you then lose all changes past that point
|
|
| Apr 10, 2022 at 21:16 | history | migrated | from stackoverflow.com (revisions) | ||
| Apr 10, 2022 at 14:24 | comment | added | David Browne - Microsoft | Please clarify, what are the filegroups? Which ones are read/write and which are read-only? Which ones are present in your backups? Why are you doing a restore? Where are your full backups? Why don't you have log backups? | |
| Apr 10, 2022 at 14:01 | history | asked | Sergio Ivan Prieto Muete | CC BY-SA 4.0 |