SQL Server Backup Recovery maintenance plan for backups: Weekly Database Full backups, daily differential backups, hourly log Backups

in database management, database backup is very important. The Maintenance Plan Wizard makes it easy to complete a database backup.

The following example shows how to implement a backup of a database with a backup strategy of One full backups per Sunday, differential daily backups (except Sunday), and hourly log backups.

In addition, you can specify to delete outdated backup policies, for example, to remove backups from 10 days ago because hard disk space is limited.

 1. 2.3.4, here you can customize the name, here with the default Maintenanceplan, and also selected "Each task separate plan", so that each task can be specified separately: The period of execution, time interval, etc. 5. Select "Backup Database (Full)", "Backup Database (diff)", "Backup Database (transaction log) "6, the maintenance plan, the first "database backup (complete)", then make a differential backup, and finally a transaction log backup. 7. First set up "Backup Database (Full)" and select the database to be backed up. 8. Specify the path where the backup file is stored: E:\DB_Backup. 9. Specify the type of execution, frequency of execution, interval, start time, end time. 10, Next is to set up a differential backup, as with the full backup above, you also need to set up the database to be backed up,specify the path where the backup file is stored: E:\DB_Backup。11. Set the schedule type, frequency, interval, start time, end time of the differential backup. 12, set the database for transaction log backup, the path of log backup: E:\DB_Backup. 13. Set the execution type, frequency, interval, start and end time for transaction log backups.  14. Set whether the report is written to a file or sent as a message. 15, complete the wizard. 16, set the success. 17. Double-click the maintenance plan on the left to pop up the edit window on the right. From the toolbox in the lower left, drag clear history, clear maintenance, and point the green arrow for the full backup to clear history, and then point the green arrow for clear history to clear maintenance. 18, double-click the "Clear history" box, pop Up the Settings dialog box, select the time of retention, more than the retention time, the full backup record will be deleted. 19, double-click the "Clear Maintenance" box, pop Up the Settings dialog box, choose the time of retention, more than the retention time, the full backup file will be deleted, note the path to set the backup file, and the extension bak, not. bak. 20, after the setup is complete, this is the case. 21, the following two sub-plans, also in a similar way to modify it.

Original source: http://blog.csdn.net/sqlserverdiscovery/article/details/11020057

SQL Server Backup Recovery maintenance plan implementation backup: Weekly database full backup, daily differential backup, hourly log backup