You can create a backup schedule using Maintenance Plans inside of the Microsoft SQL Server Management Studio. To create a backup schedule, please follow these simple steps:
- Go To SQL Server Configuration Manager > SQL Server Services > Run SQL Server Agent (Set it to Run Automatically)
- Go To SQL Server Management Studio, Find the TAB labeled Management > Maintenance Plans.
- Right Click > Maintenance Plans Wizard.
- Give your plan a name, ex: DailyBackup.
- Select Option button : Single Schedule for entire task.
- Click Configure > Set Schedule according your needs.
- Select Maintenance tasks. For this case, you would choose Full Database backup.
- Click Next, then define which database(s) to backup, set backup location, and backup extension.
- Click Next, Choose your report mode, then Finish.
Please note that the instructions above may vary slightly depending on your version of Microsoft SQL Server Management Studio.