SQL Server DBA Tutorial 75-How to Create Backup Maintenance Plan in SQL Server

In this video you will learn how to create Database Backup Maintenance Plan step by step. After watching this video, you will be able to create new maintenance plan, navigate to the Tool Box, Navigate to the database backup task, configure database Task, step by step walk through maintenance plan options and whether to select system database, user database, all database or selective databases. You will also learn how to view maintenance plan and SQL Server Agent Jobs for newly created maintenance plan.

To Follow Step by Step for SQL Server DBA Video Tutorial By Tech Brothers

[birukarbas]

i really don't understand whats the difference between job and maintenance plan it just confusing to me . by the way grate videos thanks

[sherwinIlog]

Hi. How about differential and transaction log backup?

[shahnawajalam]

can i choose a folder located in NAS as the destination of Backup..?

[SumitKumar-lbxn]

i have a database of 6tb in which a table is of 5tb, we will have to rebuild the indexes on it as maintenance plan but this plan fails evertime becauase log space are getting full. DB model is simple recovery and we rebuilding the index online, any sugeestion how to rebuild index on such a large database or table

[Sodara-]

Hi Bro, How can we back sql server to store on the share folders?