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?
Best Answer
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.