0

In addition to a nightly full backup, I'd like to set up an hourly differential backup maintenance plan in SQL Server 2012, where each differential backup file should receive a different name. It seems this isn't possible. Am I overlooking something simple?

In the GUI interface, my choices are either to append to the target differential backup file, or to overwrite it. Is there a way to append _{YEAR}{MO}{DY}{HH} to the differential filename?

Improve this question
1
  • If you use maintenance plans or Ola H's scripts, it will do this for you. You shouldn't need to manually (or via the GUI, for that matter) take differential backups.
    – Kris Gruttemeyer
    Commented Mar 4, 2015 at 18:02

1 Answer 1

Reset to default
2

You should use Ola's backup solution. Brad talks about it in more details on simple talk.

The solution is very simple to implement and its tested by many organizations.

Value Description

FULL Full backup

DIFF Differential backup

LOG Transaction log backup

Improve this answer

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.