question

Hammer715 avatar image
Hammer715 asked

SQL differential Chain

If I have a full daily and then run the differential ever hour after the full can I remove any of the differential files in the chain to reduce storage space.
sqlbackuplog-backupdifferential-backup
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
Yes, you can remove any differential backup up to the most recent one. The differential backup will include anything that has changed since the most recent FULL backup. However, keep in mind that a backup is only as good as the last time you've restored it. In other words, if you delete all the previous backups and the most recent one is corrupt, then you might be hosed. Just something to think about. Hope this helps!
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.