Couple days ago, I’ve found that almost every database server at our customers environment, doesn’t have any backup schedule, or they have but it didn’t run properly. When I see at job history, there are so many error, which means that job was unsuccessfully run. So I made a plan to modify or recreate every job schedule to automatically backup all customers databases.
I use SQL server maintenance plan to accomplish the task as following step :
Step 1 :
Open SQL Server Management Studio (SSMS), connect to Database engine, expand Management, Right click on Maintenance Plans and then click New Maintenance Plan