How to create a backup Maintenance Plan in SQL Server

Author: Voluntary DBA
85404 View
6m 54s Lenght
130 Rating

Maintenance Plans are an easy, simple way to get started with a backup solution. In this video, watch Microsoft Certified IT Professional Jon Seigel show you how to create a backup Maintenance Plan that includes full, differential, and transaction log backup subplans. Blog post for this video: http://voluntarydba.com/post/2012/10/18/Creating-a-Backup-Maintenance-Plan.aspx Visit my channel for more database administration videos: https://www.youtube.com/voluntarydba Subscribe to get notified about my latest videos: https://www.youtube.com/voluntarydba?sub_confirmation=1 Read additional content on my blog: http://voluntarydba.com Follow on Twitter: https://twitter.com/voluntarydba Like on Facebook: https://facebook.com/voluntarydba

Comments

  1. This was wonderful. Thank you for taking the time to create this!!!!
  2. Hi, Mantainance Plan offers a lot more options such as Check database Integrity, Shrink Database, Reorganize index and so on. I would like to know the best order to run this tasks, for example should I Reorganize before or after backup or shuld I rebuild Index if I don't reorganize? Or should I do this things at all? I'm having problems with a 2GB database that has a lot of use and get slow and sometimes generate deadlocks. It fixes for a while when I run a script that shrinks the database/transaction log. I was reading that a backup even as frequent as 15 minutes can be a real solution. I'm now in full recovery mode. Sorry for the long question.
  3. Can you please tell the difference between Full, Differential and Transaction Log? and if I'm taking a backup how can I save old and new backup ( will it overwrite each time)?
  4. In terms of purely backing up databases, how would you say this method performs in relation to setting it up through SSIS, My business has SSIS but they use these style of maintenance plans instead and I am wondering what the pros and cons are of each
  5. How about recorvery on this video?
  6. how can recover a DB from a backup file?
  7. pls sir share me you sql sever 2008 R2 full version software
    I hope there I will get Maintenance Plan folder .... pls pls pls pls pls pls pls
  8. εντε ρε
  9. Please you can help me, why when I install SQL server 2012 not appear <<SQL Server Agent>>in SQL Managment Studio.
    While I installing all this files
    1-SQL Managment Studio - Complete
    2- SSDTBI_VS2012_x64_ENU
    3- SQLEXPR_x64_ENU
    4- SQLEXPRADV_x64_ENU
    5- SQLEXPRWT_x64_ENU
    6- SqlLocalDB

    Thanx for all you cooperation
  10. Great video. Would be worth mentioning when or how truncation of logs happens.
  11. Thank you!!!!!! Thanks a lot man!!!!!... 
  12. Fantastic video!
    Could you please brush up on how to schedule a backup maintenance plan?

    Kind Regards
  13. Thanks, it showed me how easy is to do the maintenance plan. 
  14. Thanks a lot. It helped me in learning things.
  15. Very nicely done. 
  16. Good stuff.  Can you set a backup to a networked drive?
  17. I like the demo, thanks for that!
  18. Please let me know if the Hindi closed captions were helpful by voting on this comment or by leaving a reply. Thank you!