SQL Server 2016 - Maintenance and Automation

Simpliv

Course

Online

£ 150 VAT inc.

The best Other programming courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Safeguard your business continuity and database with the help of Backup, Automation, and Disaster Recovery.Microsoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer. In this video tutorial, you will start with diving into Backup and Recovery of your Database. Here, you will learn to develop a backup strategy and carry out full database backups as well as differential database backups. You will explore the different options for restoring your system logs, and how to restore your database’s state to a specified point in time. From there, you will move on to Automating your Server. You will learn to create tasks and jobs for your system, and also set up operations and notifications. You will also learn to configure alerts and database emails for sending messages to users. After that, you will dive right into High Availability and Disaster Recovery, where you will database mirroring, log shipping, and availability groups. Finally, you will explore the different types of server and data replication and how they are used. By the end of this video tutorial, you will be well versed with automating and maintaining your own database using SQL Server.About the AuthorSteve Jones has been working with SQL Server since 1991. He has worked with all versions of SQL Server as a developer and DBA, in a variety of industries and companies. Over the last 25 years, he been very pleased with the enhancements and growth of the platform. He feels that SQL Server is an outstanding database platform well-suited to a wide variety of needs and situations..
In 2001, Steve founded SQLServerCentral.com with Brian Knight, Andy Warren, and three other partners

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Create a backup strategy and perform full and differential restores
Configure and use a database mail to send messages under server automation
Create full database backups and work with different actions
Install and configure ‘Always On’ availability groups
Create operations and notifications based on server options

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Options
  • Server
  • Database
  • SQL
  • Database training
  • Database Management
  • Database Administration
  • Data analysis
  • Data Management
  • Information Systems

Course programme

Backup and Recovery 8 lectures 50:24 The Course Overview This video gives an overview of our entire course Backup Strategy In this video, we will learn to build a backup strategy for your databases based on the needs of your organization.
  • Define an RTO for each group of databases
  • Define an RPO for each group of databases
  • Use these definitions to determine the frequency and type of the backup
Full Database Backups In this video, we will perform a full database backup with the options necessary for your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Add a filename for your backup with the .bak extension
  • Set the parameters for backup on the two Options tab
Differential Database Backups In this video, we will perform a differential database backup.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select a differential backup and choose a filename with the .dff extension
  • Set the parameters for backup on the two Options tab
Transaction Log Backups In this video, we will perform a transaction log backup of your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select transaction log backup and choose a filename with the .trn extension
  • Set the parameters for backup on the two Options tab
Basic Database Restores In this video, we will restore a backup file as a new database.
  • Right-click on a database and select Tasks, Restore, Database in SSMS
  • Choose a backup file in the dialogand select "Move" in the Files tab
  • Select the NORECOVERY option to allow for more files to be restored
Restoring Transaction Logs In this video, we will restore a log backup to meet a more detailed RPO.
  • Right-click on a database and select Tasks, Restore, Transaction Log in SSMS
  • Choose a backup file in the dialog
  • Select the NORECOVERY option if more logs need to be restored
Restoring to a Point in Time In this video, we will restore a transaction log to a point in time.
  • Right-click on a database and select Tasks, Restore, Transaction Log in SSMS
  • Choose a backup file in the dialog
  • Choose a time to restore the log to
Backup and Recovery. 8 lectures 50:24 The Course Overview This video gives an overview of our entire course Backup Strategy In this video, we will learn to build a backup strategy for your databases based on the needs of your organization.
  • Define an RTO for each group of databases
  • Define an RPO for each group of databases
  • Use these definitions to determine the frequency and type of the backup
Full Database Backups In this video, we will perform a full database backup with the options necessary for your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Add a filename for your backup with the .bak extension
  • Set the parameters for backup on the two Options tab
Differential Database Backups In this video, we will perform a differential database backup.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select a differential backup and choose a filename with the .dff extension
  • Set the parameters for backup on the two Options tab
Transaction Log Backups In this video, we will perform a transaction log backup of your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select transaction log backup and choose a filename with the .trn extension
  • Set the parameters for backup on the two Options tab
Basic Database Restores In this video, we will restore a backup file as a new database.
  • Right-click on a database and select Tasks, Restore, Database in SSMS
  • Choose a backup file in the dialogand select "Move" in the Files tab
  • Select the NORECOVERY option to allow for more files to be restored
Restoring Transaction Logs In this video, we will restore a log backup to meet a more detailed RPO.
  • Right-click on a database and select Tasks, Restore, Transaction Log in SSMS
  • Choose a backup file in the dialog
  • Select the NORECOVERY option if more logs need to be restored
Restoring to a Point in Time In this video, we will restore a transaction log to a point in time.
  • Right-click on a database and select Tasks, Restore, Transaction Log in SSMS
  • Choose a backup file in the dialog
  • Choose a time to restore the log to
The Course Overview This video gives an overview of our entire course The Course Overview This video gives an overview of our entire course The Course Overview This video gives an overview of our entire course The Course Overview This video gives an overview of our entire course This video gives an overview of our entire course This video gives an overview of our entire course Backup Strategy In this video, we will learn to build a backup strategy for your databases based on the needs of your organization.
  • Define an RTO for each group of databases
  • Define an RPO for each group of databases
  • Use these definitions to determine the frequency and type of the backup
Backup Strategy In this video, we will learn to build a backup strategy for your databases based on the needs of your organization.
  • Define an RTO for each group of databases
  • Define an RPO for each group of databases
  • Use these definitions to determine the frequency and type of the backup
Backup Strategy In this video, we will learn to build a backup strategy for your databases based on the needs of your organization.
  • Define an RTO for each group of databases
  • Define an RPO for each group of databases
  • Use these definitions to determine the frequency and type of the backup
Backup Strategy In this video, we will learn to build a backup strategy for your databases based on the needs of your organization.
  • Define an RTO for each group of databases
  • Define an RPO for each group of databases
  • Use these definitions to determine the frequency and type of the backup
In this video, we will learn to build a backup strategy for your databases based on the needs of your organization.
  • Define an RTO for each group of databases
  • Define an RPO for each group of databases
  • Use these definitions to determine the frequency and type of the backup
In this video, we will learn to build a backup strategy for your databases based on the needs of your organization.
  • Define an RTO for each group of databases
  • Define an RPO for each group of databases
  • Use these definitions to determine the frequency and type of the backup
Full Database Backups In this video, we will perform a full database backup with the options necessary for your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Add a filename for your backup with the .bak extension
  • Set the parameters for backup on the two Options tab
Full Database Backups In this video, we will perform a full database backup with the options necessary for your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Add a filename for your backup with the .bak extension
  • Set the parameters for backup on the two Options tab
Full Database Backups In this video, we will perform a full database backup with the options necessary for your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Add a filename for your backup with the .bak extension
  • Set the parameters for backup on the two Options tab
Full Database Backups In this video, we will perform a full database backup with the options necessary for your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Add a filename for your backup with the .bak extension
  • Set the parameters for backup on the two Options tab
In this video, we will perform a full database backup with the options necessary for your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Add a filename for your backup with the .bak extension
  • Set the parameters for backup on the two Options tab
In this video, we will perform a full database backup with the options necessary for your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Add a filename for your backup with the .bak extension
  • Set the parameters for backup on the two Options tab
Differential Database Backups In this video, we will perform a differential database backup.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select a differential backup and choose a filename with the .dff extension
  • Set the parameters for backup on the two Options tab
Differential Database Backups In this video, we will perform a differential database backup.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select a differential backup and choose a filename with the .dff extension
  • Set the parameters for backup on the two Options tab
Differential Database Backups In this video, we will perform a differential database backup.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select a differential backup and choose a filename with the .dff extension
  • Set the parameters for backup on the two Options tab
Differential Database Backups In this video, we will perform a differential database backup.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select a differential backup and choose a filename with the .dff extension
  • Set the parameters for backup on the two Options tab
In this video, we will perform a differential database backup.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select a differential backup and choose a filename with the .dff extension
  • Set the parameters for backup on the two Options tab
In this video, we will perform a differential database backup.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select a differential backup and choose a filename with the .dff extension
  • Set the parameters for backup on the two Options tab
Transaction Log Backups In this video, we will perform a transaction log backup of your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select transaction log backup and choose a filename with the .trn extension
  • Set the parameters for backup on the two Options tab
Transaction Log Backups In this video, we will perform a transaction log backup of your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select transaction log backup and choose a filename with the .trn extension
  • Set the parameters for backup on the two Options tab
Transaction Log Backups In this video, we will perform a transaction log backup of your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select transaction log backup and choose a filename with the .trn extension
  • Set the parameters for backup on the two Options tab
Transaction Log Backups In this video, we will perform a transaction log backup of your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select transaction log backup and choose a filename with the .trn extension
  • Set the parameters for backup on the two Options tab
In this video, we will perform a transaction log backup of your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select transaction log backup and choose a filename with the .trn extension
  • Set the parameters for backup on the two Options tab
In this video, we will perform a transaction log backup of your database.
  • Right-click on a database and select Tasks, Backup in SSMS
  • Select transaction log backup and choose a filename with the .trn extension
  • Set the parameters for backup on the two Options tab
Basic Database Restores In this video, we will restore a backup file as a new database.
  • Right-click on a database and select Tasks, Restore, Database in SSMS
  • Choose a backup file in the dialogand select "Move" in the Files tab
  • Select the NORECOVERY option to allow for more files to be restored
Basic Database Restores In this video, we will restore a backup file as a new database.
  • Right-click on a database and select Tasks, Restore, Database in SSMS
  • Choose a backup file in the dialogand select "Move" in the Files tab
  • Select the NORECOVERY option to allow for more files to be restored
Basic Database Restores In this video, we will restore a backup file as a new database.
  • Right-click on a database and select Tasks, Restore, Database in SSMS
  • Choose a backup file in the dialogand select "Move" in the Files tab
  • Select the NORECOVERY option to allow for more files to be restored
Basic Database Restores In this video, we will restore a backup file as a new database.
  • Right-click on a database and select Tasks, Restore, Database in SSMS
  • Choose a backup file in the dialogand select "Move" in the Files tab
  • Select the NORECOVERY option to allow for more files to be restored
In this video, we will restore a backup file as a new database.
  • Right-click on a database and select Tasks, Restore, Database in SSMS
  • Choose a backup file in the dialogand select "Move" in the Files tab
  • Select the NORECOVERY option to allow for more files to be restored
In this video, we will restore a backup file as a new database.
  • Right-click on a database and select Tasks, Restore, Database in SSMS
  • Choose a backup file in the dialogand select "Move" in the Files tab
  • Select the NORECOVERY option to allow for more files to be restored
Restoring Transaction Logs In this video, we will restore a log backup to meet a more detailed RPO.
  • Right-click on a database and select Tasks, Restore, Transaction Log in SSMS
  • Choose a backup file in the dialog
  • Select the NORECOVERY option if more logs need to be restored
Restoring Transaction Logs In this video, we will restore a log backup to meet a more detailed RPO backup file in the dialog
  • Choose a time to restore the log...

Additional information

Basic knowledge of SQL Server is required

See related categories

SQL Server 2016 - Maintenance and Automation

£ 150 VAT inc.

The best Other programming courses

See all

See all