How To Set Up An Automated Backup in MS SQL
Creating an automated backup plan for MS SQL servers has been made more accessible to new users of MS SQL. Follow these 16 simple steps to automate the backup process of your MS SQL database.
- Login to SQL management Studio
- Connect to the correct database
- Make sure the SQL server agent is running / Start SQL server agent
- Expand “Management” inside the explorer
- Select “Maintenance plans”
- Right-click “Maintenance plans”
- Select “New Maintenance plan”
- Create a name for the new plan in the popup box
- Select the calendar menu from the right hand side of the maintenance plan
- Inside the job scheduling window, configure the frequency and times of your backup plan
- Click “okay” to set scheduling
- Select “back up database task” from the tasks pane on the lower left side
- Drag this selection into the panel on the right side to add to new maintenance plan
- Double click “back up database task” in the right panel
- Inside the new popup window, configure the databases for the backup plan
- Click “okay” to finish the backup plan configuration.
Now your MS SQL backup plan has been configured to run automatically. This should provide an adequate level of fault protection within the MS SQL database architecture. However, depending upon the frequency of the backup plan, administrators may want to automate the function of purging old database backup files. This process is similar to the scheduling of the automated backups and will be covered here in a follow-up post.