0

Hi is it possible to do a differential backup in ssms 2014, so that it gets all changes since a specified date?

2
  • 1
    A differential backup will be all changes since the last full backup. There is no way to say only give me the changes since some other date/time. Commented Apr 14, 2015 at 15:59
  • I know you can use the transaction log to restore your database to specific dates if you have it in BULK_LOGGED or FULL recovery mode so you might be able to figure out a solution using logs
    – Stephan
    Commented Apr 14, 2015 at 16:07

1 Answer 1

2

Differential backups are backups of any changes to the DB since the last full backup. So in theory, yes, you could have it do a diff backup since some date (if you did a full backup on that date). Otherwise, no. It'll always be since the last full backup.

3
  • Oh so it's since the last full backup? What about since the last differential backup?
    – Vandel212
    Commented Apr 14, 2015 at 16:05
  • 2
    What about since the last differential backup? You have to take Transaction log backups.
    – Kin Shah
    Commented Apr 14, 2015 at 17:02
  • @Kin is correct, sorta. Log backups give you any changes since the last Log backup, not the last Differential. There is no type of backup that will give you all the changes SINCE the last Diff. However, Logs are the next "more incremental" type of backup compared to Diffs. Commented Apr 15, 2015 at 17:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.