Click here to Skip to main content
15,798,508 members
Articles / Programming Languages / SQL
Tip/Trick

SQL 2012 Scheduling Auto Backup

Rate me:
Please Sign up or sign in to vote.
3.42/5 (5 votes)
9 Jul 2013CPOL 85.9K   8   5
How to do scheduling auto backup in SQL 2012

Introduction

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

  1. Open SSMS and connect to SQL Authentication.

    Image 1

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

    Image 2

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

    Image 3

  4. New maintenance plan has been created like this:

    Image 4

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

    Image 5

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

    Image 6

  7. Backup types on the window like this:

    Image 7

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

    Image 8

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

    Image 9

  10. Select the backup format like bak, etc…

    Image 10

  11. Verify backup Integrity to user defined mode.

    Image 11

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

    Image 12

  13. So double click the maintenance cleanup task.

    Image 13

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

    Image 14

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

    Image 15

License

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


Written By
Database Developer NEELKANTH DIGITAL INFONET
India India
Production & Application DBA ,Asst Programmer

Comments and Discussions

 
Questiona nice tip anyway Pin
netfed29-May-14 13:01
netfed29-May-14 13:01 
SuggestionBetter soluion for this task Pin
namaste2sadhu24-Apr-14 0:28
namaste2sadhu24-Apr-14 0:28 
GeneralMy vote of 1 Pin
nobodyxxxxx10-Jul-13 21:37
nobodyxxxxx10-Jul-13 21:37 
SuggestionExpress Edition Pin
Wendelius9-Jul-13 19:52
mentorWendelius9-Jul-13 19:52 
AnswerRe: Express Edition Pin
apachearun9-Jul-13 20:41
apachearun9-Jul-13 20:41 

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

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