Click here to Skip to main content
11,410,118 members (47,853 online)
Click here to Skip to main content

Tagged as

SQL 2012 Scheduling Auto Backup

, 9 Jul 2013 CPOL
Rate this:
Please Sign up or sign in to vote.
How to do scheduling auto backup in SQL 2012


This tip lists how to schedule auto backup in SQL 2012.

  1. Open SSMS and connect to SQL Authentication.

  2. Open Management Tab, then Maintenance plan, new maintenance plan.

  3. Create new maintenance plan, then give name to it.

  4. New maintenance plan has been created like this:

  5. Open the Tool box, select Backup database task.

  6. After create Backup database task, doubleclick the box backup database task.

  7. Backup types on the window like this:

  8. Next is Database selection all DBs or Single DB.

  9. Choose the Backup type disk or tape, then Designation.

  10. Select the backup format like bak, etc…

  11. Verify backup Integrity to user defined mode.

  12. After completing all steps. Go to toolbox, select the Cleanup box.

  13. So double click the maintenance cleanup task.

  14. Choose new for the new connection as same as SQL authentication.

  15. Type the backup type, then backup expire date then OK ,that's all.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

India India
Production & Application DBA ,Asst Programmer

Comments and Discussions

Questiona nice tip anyway Pinmembernetfed29-May-14 13:01 
SuggestionBetter soluion for this task Pinmembernamaste2sadhu24-Apr-14 0:28 
The same task can be solved using EMS SQL Backup.
GeneralMy vote of 1 PinprofessionalH. Mueller10-Jul-13 21:37 
SuggestionExpress Edition PinmvpMika Wendelius9-Jul-13 19:52 
AnswerRe: Express Edition Pinprofessionalapachearun9-Jul-13 20:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.150414.5 | Last Updated 10 Jul 2013
Article Copyright 2013 by apachearun
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid