The downside of Maintenance Plans is that the tasks that Maintenance Plans provide are basic and don’t leave space for customization.Ī Maintenance Plan is also atomic and is therefore not able to run multiple tasks.
Maintenance Plans are more suitable for less experienced DBAs because they provide an easy to use GUI, and do not require manually written maintenance scripts.
In the opened window set up, the configuration related to the database backup. Now you need double-click on the database task. Now choose from the left-side window, select the Backup Database Task to set up the backup process and drag the element onto the right window as shown in the picture. In the opened window set up all necessary backup schedule. It will bring up the job schedule screen. Press on the calendar icon on the top-right highlighted section on the job schedule screen.
Mysql management studio tutorial how to#
How to Backup SQL Database AutomaticallyĮnter the name of the Maintenance Plan you are going to create. Then right-click on Maintenance Plan folder and select New Maintenance Plan. Open the folder named Management and find the Maintenance Plan folder. Go to the Object Explorer window (located on the left) and make sure that your SQL Server Agent is running. Log into SQL Server Management Studio (SSMS) and connect to the database. To automate and schedule a backup with SQL Server Agent: These are the following steps you need to follow in order to create a.