Timeline for SQL Diff Backup not using latest full
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 11, 2020 at 12:31 | comment | added | Dominique Boucher | It's the first time I see such a backup strategy (full daily and diff hourly). I'm curious to know what is the reason for such a backup strategy ? P.S. The log backup are different backup then full backup (even if the full backup does backup some part of the log file). If you do diff backup in order to make sure you won't lose more then 1 hour of data, maybe you should look at setting the DB to the full recovery model and simply have log backup hourly. | |
| Mar 11, 2020 at 12:21 | comment | added | Tibor Karaszi | You can use a query that periodically polls the modified_extent_change_count column in sys.dm_db_space_usage DMV. Schedule it every minute and store the value in a table with a date and time. Then you can use this to hunt down in time when these modifications occurred. | |
| Mar 11, 2020 at 12:17 | answer | added | Elliott | timeline score: 1 | |
| Mar 11, 2020 at 11:12 | answer | added | zapcon | timeline score: 0 | |
| Mar 11, 2020 at 10:51 | comment | added | Elliott | The workload of the database is no different from the other servers we operate if anything it will be lower than most of them. The update activity again should not be different from the other servers. The busiest servers have differentials that are a few hundred MB by the end of the day, no where near this size. The transaction logs are backed up as part of the full backup i believe. | |
| Mar 11, 2020 at 10:48 | comment | added | Tony Hinkle | If the DB is in full recovery mode, are you backing up the transaction logs regularly? How often? | |
| Mar 11, 2020 at 10:13 | comment | added | Dan Guzman | It seems there's may be significant update activity between the full and first differential backup, such as index maintenance. | |
| Mar 11, 2020 at 10:12 | comment | added | Denis Rubashkin | What's about the database's workload? | |
| Mar 11, 2020 at 9:56 | history | migrated | from stackoverflow.com (revisions) | ||
| Mar 11, 2020 at 9:24 | history | asked | Elliott | CC BY-SA 4.0 |