Microsoft SQL Server Backup and Recovery for beginners

Focused View

Bluelime Learning Solutions

1:20:39

9 View

1. SQL Server Setup

1. Introduction.mp4

00:20

2. What is SQL Server.mp4

02:57

3. SQL Server Editions.mp4

04:45

4. Download SQL Server.mp4

04:31

5. Install SQL Server.mp4

09:43

6. Install SQL Server Management Studio -SSMS.mp4

05:48

7. Connect SSMS to SQL Server.mp4

07:46

8. Install Sample Database.mp4

06:28

2. Database Backup and Recovery

1. Please Read.html

2. Glossary of backup terms.html

3. Backup and restore strategies.html

4. Copy Database.mp4

03:03

5. Performing Full Backup.mp4

09:19

6. Performing Differential Backup.mp4

08:43

7. Performing Transactional Backup.mp4

06:56

8. Recovery a Database.mp4

07:14

9. Lab Exercise 1.mp4

02:31

10. Lab Exercise 2.mp4

00:35

Description

Back Up and Restore of SQL Server Databases

What You'll Learn?

Install Sample Database
Perform Full Database Backup
Perform Differential Database Backup
Perform Transactional Database Backup
Recover Database from Backup

Who is this for?

Beginners to SQL Server Database Backups and Recoveries

What You Need to Know?

Requirements covered in the course.

More details

Description
The SQL Server backup and restore component provides an essential safeguard for protecting critical data stored in your SQL Server databases. To minimize the risk of catastrophic data loss, you need to back up your databases to preserve modifications to your data on a regular basis. A well-planned backup and restore strategy helps protect databases against data loss caused by a variety of failures. Test your strategy by restoring a set of backups and then recovering your database to prepare you to respond effectively to a disaster.

Why back up?
Backing up your SQL Server databases, running test restores procedures on your backups, and storing copies of backups in a safe, off-site location protects you from potentially catastrophic data loss. Backing up is the only way to protect your data.
With valid backups of a database, you can recover your data from many failures, such as:

Media failure.
User errors, for example, dropping a table by mistake.
Hardware failures, for example, a damaged disk drive or permanent loss of a server.
Natural disasters. By using SQL Server Backup to Azure Blob storage service, you can create an off-site backup in a different region than your on-premises location, to use in the event of a natural disaster affecting your on-premises location.
Additionally, backups of a database are useful for routine administrative purposes, such as copying a database from one server to another, setting up Always On availability groups or database mirroring, and archiving.
Who this course is for:
Beginners to SQL Server Database Backups and Recoveries

User Reviews

Rating

average 0

Total votes0

Focused display

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.