SQL Server 2012 Automatic backup

SQL 2012 and 20,081, you can do a maintenance plan to automatically backup the database.

Now for a database maintenance plan, make a differential backup of the database at 0 points per day, make a full backup of the database every Sunday 0 o'clock, and delete an expired backup (two weeks ago) every night 10 o'clock.

The following methods are used to make such a maintenance plan:

Before you make a plan, you need to enable SQL Server Agent and set the startup mode to Automatic.

Next, click on "SQL Server Management Studio"--"management"--"maintenance plan"--"Maintenance Plan Wizard"--"Maintenance Plan Wizard"

Here because there are three plans, and each plan cycle is different, select "Each task is planned separately".

Then, according to the requirements of the maintenance task, I chose the "Backup Database (Full)", "Backup Database (diff)", "Clear maintenance" task "three

Then start defining each task, first defining the backup database (full) task, I'm backing up SharePoint, so I chose the content database wss_content for the specific database SharePoint. and select the backup set expires after 14 days (the settings here are useful for clear maintenance tasks), and finally choose the folder you need to write to the backup, such as D:/backup/full;

Then the definition of the "Backup Database (diff)" task, the same selection of a specific WSS_Content database, the selected expiration time is 14 days, select the folder to write to the backup, such as D:/backup/diff;

Finally, define the "Clear Maintenance" task, select "Backup File" in the deletion of the following types of files, select the Search Folder at the file location d:/backup, file extension bak, tick include the first level subfolder, select 2 weeks in the file retention time, change the schedule "22:00:00 execution" in the day.

Then always click "Next" until the Maintenance Plan Wizard is complete, but here the maintenance plan is not finished, the first two tasks are not planned, you need to plan for them separately

Here, set the schedule for the full backup to be backed up every Sunday 0 o'clock, and set up a daily backup schedule for the differential backup.

Finally, save the maintenance plan so that the backup plan for the SharePoint content database is completed.

SQL Server 2012 Automatic backup