SQL Server backup using SQL Server Maintenance Plans

SQL Server backup using SQL Server Maintenance Plans

by admin
Want create site? Find Free WordPress Themes and plugins.

SQL Server backup using SQL Server Maintenance Plans

If you are running SQL Server on AWS EC2, the responsibility of taking backups remains the responsibility of the user.

The different types of backups available are as below:

* FULL Database Backup: This is the most extensive method of backing up your data and involves creating a copy of your entire data and objects.

* Differential Database Backup: A differential backup is based on the most recent, previous FULL backup of the data that is included in the differential backup. A differential backup captures only the data that has changed since that FULL backup. This is known as the base of the differential. A differential backup includes only the data that have changed since the differential base.

* Transaction log backup. This backup type will backup all of the transactions that have occurred since the last log backup or truncation, then it will truncation the transaction logWith a transaction log backup, you can restore a database to a particular point in time aka point-in-time recovery, like right before a data loss event

There are 2 ways to schedule SQL Server backups:

  1. Using SQL Agent jobs
  2. Using the Maintenance plan.

In this blog, we will try to explain how to take backups using the Maintenance plan,

Steps to Create a maintenance plan in SQL Server

 * Login to the server using DB Admin credentials.

* Expand the Management Node

oject explorer - SQL Server backup using SQL Server Maintenance Plans

* Right-click on the maintenance node

right click - SQL Server backup using SQL Server Maintenance Plans

* Go through with New maintenance plan

* Give a Name For Maintenance Plan

new name - SQL Server backup using SQL Server Maintenance Plans

* Click OK

 * Schedule the Maintenance plan

Maintenance Plan - SQL Server backup using SQL Server Maintenance Plans

 

 

* Schedule the Plan for runs per Our requirement. (Weekly, Daily, Hourly)

job schedule properties - SQL Server backup using SQL Server Maintenance Plans

 

*  Select the various Maintenance Tasks

Maintenance plan wizard - SQL Server backup using SQL Server Maintenance Plans

* Select Plan Properties

Maintenance plan wizard 2 - SQL Server backup using SQL Server Maintenance Plans

* Update the Define statistics

Maintenance plan wizard 3 - SQL Server backup using SQL Server Maintenance Plans

* Add The task details.

Maintenance plan wizard 4 - SQL Server backup using SQL Server Maintenance Plans

* Verify the details and click finish

Maintenance plan wizard 5 - SQL Server backup using SQL Server Maintenance Plans

* It will create a Maintenance plan and job

That’s it, your backups are scheduled on the server and you can move them to standard storage like AWS S3 for retention.

Did you find apk for android? You can find new Free Android Games and apps.

Leave a Reply

Your email address will not be published. Required fields are marked *