Hello. Thanks for visiting.

Have questions about Server Intellect?

I'm here to help.

Call us toll free at 1-855-850-HOST(4678)

Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

SQL Agent Jobs: Creating a Scheduled Database Backup Plan

Prerequisites

Microsoft SQL Server (Any edition but Express)

Procedure

RDP onto the server

Connect to the SQL server using SQL Server Management Studio. You need administrative access so use Windows credentials or the SA account

Expand the Management section

Right-click on Maintenance Plans and choose New Maintenance Plan

Choose a name, E.G. “Daily Backup

Double click on Subplan_1

  • Name: A simple name for the section of the plan (e.g. Backup)
  • Description: Provide some more detail explanation (e.g. Takes a daily backup and deletes the one created the previous day)
  • Click on the calendar icon next to the Schedule field. Change the frequency according to customer’s specifications

On the left-hand side there will be a toolbox containing call the available tasks

Add a Back Up Database Task. You can either double click it, or drag and drop it into the beige filed

A new item will appear in the design area

Double click on the Icon to set up the backup specifications

Specify the databases to back up. You can click on “All user databases“, or select specific ones using the “These Databases” option

Click OK

Select the Create a backup file for every database option

Check the box that says “Create a sub-directory for each database

Select a location for the backup files (Usually something along the lines of “C:\SQL Backups”)

Hit OK

You are done setting the backup part of the plan, now we need to make it remove the old files

Add a Maintenance Cleanup Task from the toolbox. Make sure to connect it by dragging the arrow from the backup task onto it

Double-click on the Icon for the new task

On the folder section, select the folder where you are backing up the files

For file extension, select *.*

Check the “Include first-level sub-folders” box

Choose the time frame for file deletion. If it’s a daily backup task, set the time to 20 hours, not 1 day, so we ensure the prior day’s backup is removed

Save the plan by clicking on the Save icon or hitting Ctrl + S and you’re done!

Having Problems with Windows Server?

Try our troubleshooting service

  • Microsoft Certified Engineers
  • Remote Log-in to Your Servers
  • End-to-End Troubleshooting

Our Certified Technicians have been supporting Microsoft® products for well over a decade.

Tell us where you are getting stuck

Get Help Now!

Having Trouble Solving This Problem?

Let our Microsoft® Certified Engineers fix it for you.
Just $50.00 one time fee.

Having Trouble Implementing This Solution?

Why not let our Microsoft® Certified Engineers do it for you.
Just $50.00 one time fee.

Request Immediate Expert Help

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.