Timeline for How to find the last data backup on secondary replica?
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 1, 2020 at 21:31 | history | edited | David Browne - Microsoft | CC BY-SA 4.0 |
added 4 characters in body
|
| May 1, 2020 at 21:31 | vote | accept | Alex Bochkov | ||
| May 1, 2020 at 21:31 | comment | added | David Browne - Microsoft | That's actually helpful in this scenario, as you don't care what the TZ on the other server was. | |
| May 1, 2020 at 21:29 | comment | added | Alex Bochkov |
It worked! (by the way, differential_base_time has time in UTC) This time pretty close to what's recorded in msdb.dbo.backupset.backup_start_date for the FULL backup - the difference is ~1 second.
|
|
| May 1, 2020 at 21:01 | history | edited | David Browne - Microsoft | CC BY-SA 4.0 |
added 11 characters in body
|
| May 1, 2020 at 20:42 | history | answered | David Browne - Microsoft | CC BY-SA 4.0 |