mercredi 4 mars 2015

Maintenance plan to backup differentials hourly each to a new file name in SQL Server 2012


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?





Aucun commentaire:

Enregistrer un commentaire