Recently encountered a very difficult problem, SQL do not delete the data. All sorts of anxious helpless, finally still find the professional people recover the cost is not small. In order to avoid this problem, the database has to be backed up, not much nonsense said:
1. Management--maintenance plan--New Plan Wizard
2. Next Step
3. take a name-click Change
4. fill in the options--OK
5. go back to the previous window--Next
6. Select the options you want to perform daily--next
7. Adjust task Execution order
8. Select a database to back up and the path to the backup-next
9. back up the transaction log (same action as above)--Next
Ten.(Database check integrity) Select a database-next
11. Report file Select a path-next
Click "Finish" .
Complete the plan .
The above is the 2008R2 version of the database operator interface, 2012 version of the operating interface some changes in the general process and the same as above
MSSQL Daily Automatic backup