We may earn an affiliate commission when you visit our partners.
Glenn Berry
Learn how to correctly configure and use SQL Server log shipping, including troubleshooting common problems. This course is applicable to all versions of SQL Server and is aimed at DBAs, developers, and system administrators.
Read more
Learn how to correctly configure and use SQL Server log shipping, including troubleshooting common problems. This course is applicable to all versions of SQL Server and is aimed at DBAs, developers, and system administrators.
Read more
Learn how to correctly configure and use SQL Server log shipping, including troubleshooting common problems. This course is applicable to all versions of SQL Server and is aimed at DBAs, developers, and system administrators.
SQL Server log shipping is a very useful technology for high availability and disaster recovery, as well for general purpose database movement, migration, and upgrades. In this course, SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping, you'll first learn the basics of log shipping, its capabilities, and its limitations. Next, you'll learn how to prepare an environment for log shipping, and then how to configure log shipping, using either SQL Server Management Studio or T-SQL scripts. You'll learn how to monitor a log shipping environment and troubleshoot common problems, and finally you'll learn how to use log shipping for data migration and upgrading a database to a new version of SQL Server. When you've finished this course, you'll have the skills and knowledge to start configuring, using, and troubleshooting log shipping.
Register for this course and see more details by visiting:
OpenCourser.com/course/173zi9/sql
Here's a deal for you
We found an offer that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
What's inside
Syllabus
Course Overview
Introduction
Log Shipping Overview
Log Shipping Preparation Tasks
Read more
Syllabus
Course Overview
Introduction
Log Shipping Overview
Log Shipping Preparation Tasks
Read more
Configuring Log Shipping
Monitoring and Troubleshooting Log Shipping
Migrating Data Using Log Shipping
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Develops knowledge and skills related to database management and administration
Teaches technologies and techniques that are in line with industry best practices
Provides in-depth coverage of SQL Server log shipping, including its concepts, configurations, monitoring, and troubleshooting
Suitable for individuals with varied backgrounds in database management, including DBAs, developers, and system administrators
Instructed by Glenn Berry, a recognized expert in the field
Save this course
Save SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping with these
activities:
Create a study guide with notes and practice questions from the course
Show steps
Consolidate course materials for easy review and self-assessment
Browse courses on
SQL Server
Show steps
-
Review course notes and materials
-
Identify key concepts and practice questions
-
Create a study guide
SQL Server Fundamentals
Show steps
Review the basics of SQL Server to strengthen your foundation before starting the course.
Browse courses on
SQL Server
Show steps
-
Review database concepts such as tables, rows, and columns.
-
Practice writing simple SQL queries to retrieve and manipulate data.
-
Explore the SQL Server Management Studio interface and its basic functionality.
Review High-Performance MySQL
Show steps
Review an industry standard reference for SQL databases
View
High Performance MySQL: Optimization, Backups,...
on Amazon
Show steps
-
Read Chapter 1: Introduction
-
Read Chapter 2: Monitoring and Performance Tuning
Nine other activities
Expand to see all activities and additional details
Show all 12 activities
Follow a tutorial on troubleshooting common Log Shipping problems
Show steps
Supplement course material with additional troubleshooting guidance
Browse courses on
Log Shipping
Show steps
-
Find a tutorial that covers common Log Shipping problems
-
Follow the steps in the tutorial
Log Shipping Implementation Tutorial
Show steps
Follow an online tutorial to set up and configure log shipping in a test environment.
Browse courses on
Log Shipping
Show steps
-
Find a tutorial on log shipping implementation for SQL Server.
-
Follow the steps in the tutorial to create a log shipping configuration.
-
Monitor the log shipping process to ensure data is being replicated successfully.
Practice Log Shipping configuration using T-SQL scripts
Show steps
Gain proficiency in configuring Log Shipping using T-SQL
Browse courses on
Log Shipping
Show steps
-
Create a database and log shipping configuration
-
Start and stop log shipping
-
Monitor log shipping status
Log Shipping Troubleshooting Exercises
Show steps
Practice troubleshooting common log shipping issues to improve your problem-solving skills.
Browse courses on
Log Shipping
Show steps
-
Identify different types of log shipping errors.
-
Analyze error messages and understand their causes.
-
Apply problem-solving techniques to resolve log shipping issues.
Configure and troubleshoot Log Shipping for a database
Show steps
Apply the concepts learned in the course to a real-world scenario
Browse courses on
Log Shipping
Show steps
-
Create a secondary database
-
Configure Log Shipping
-
Monitor Log Shipping
-
Troubleshoot common Log Shipping problems
Log Shipping Implementation Plan
Show steps
Create a detailed plan for implementing log shipping in a production environment.
Browse courses on
Log Shipping
Show steps
-
Define the scope and objectives of the log shipping implementation.
-
Identify the source and destination databases for log shipping.
-
Configure the log shipping settings and monitoring mechanisms.
-
Develop a testing and validation plan for the log shipping implementation.
Write a blog post on the benefits and limitations of Log Shipping
Show steps
Reinforce understanding of Log Shipping by explaining it to others
Browse courses on
Log Shipping
Show steps
-
Identify the benefits and limitations of Log Shipping
-
Write the blog post
Answer questions on a discussion forum related to Log Shipping
Show steps
Reinforce knowledge by sharing it with others and clarifying concepts
Browse courses on
Log Shipping
Show steps
-
Find a discussion forum where people ask questions about Log Shipping
-
Monitor the forum for questions related to Log Shipping
-
Answer questions as you are able
Create a presentation on Log Shipping for a team meeting
Show steps
Communicate knowledge of Log Shipping to others and address potential questions
Browse courses on
Log Shipping
Show steps
-
Identify the key concepts of Log Shipping
-
Create slides that explain the benefits and limitations of Log Shipping
-
Prepare to answer questions about Log Shipping
Create a study guide with notes and practice questions from the course
Show steps
Consolidate course materials for easy review and self-assessment
Browse courses on
SQL Server
Show steps
Show steps
Show steps
- Review course notes and materials
- Identify key concepts and practice questions
- Create a study guide
SQL Server Fundamentals
Show steps
Review the basics of SQL Server to strengthen your foundation before starting the course.
Browse courses on
SQL Server
Show steps
Show steps
Show steps
- Review database concepts such as tables, rows, and columns.
- Practice writing simple SQL queries to retrieve and manipulate data.
- Explore the SQL Server Management Studio interface and its basic functionality.
Review High-Performance MySQL
Show steps
Review an industry standard reference for SQL databases
View
High Performance MySQL: Optimization, Backups,...
on Amazon
Show steps
Show steps
Show steps
- Read Chapter 1: Introduction
- Read Chapter 2: Monitoring and Performance Tuning
Nine other activities
Expand to see all activities and additional details
Show all 12 activities
Follow a tutorial on troubleshooting common Log Shipping problems
Show steps
Supplement course material with additional troubleshooting guidance
Browse courses on
Log Shipping
Show steps
Show steps
Show steps
- Find a tutorial that covers common Log Shipping problems
- Follow the steps in the tutorial
Log Shipping Implementation Tutorial
Show steps
Follow an online tutorial to set up and configure log shipping in a test environment.
Browse courses on
Log Shipping
Show steps
Show steps
Show steps
- Find a tutorial on log shipping implementation for SQL Server.
- Follow the steps in the tutorial to create a log shipping configuration.
- Monitor the log shipping process to ensure data is being replicated successfully.
Practice Log Shipping configuration using T-SQL scripts
Show steps
Gain proficiency in configuring Log Shipping using T-SQL
Browse courses on
Log Shipping
Show steps
Show steps
Show steps
- Create a database and log shipping configuration
- Start and stop log shipping
- Monitor log shipping status
Log Shipping Troubleshooting Exercises
Show steps
Practice troubleshooting common log shipping issues to improve your problem-solving skills.
Browse courses on
Log Shipping
Show steps
Show steps
Show steps
- Identify different types of log shipping errors.
- Analyze error messages and understand their causes.
- Apply problem-solving techniques to resolve log shipping issues.
Configure and troubleshoot Log Shipping for a database
Show steps
Apply the concepts learned in the course to a real-world scenario
Browse courses on
Log Shipping
Show steps
Show steps
Show steps
- Create a secondary database
- Configure Log Shipping
- Monitor Log Shipping
- Troubleshoot common Log Shipping problems
Log Shipping Implementation Plan
Show steps
Create a detailed plan for implementing log shipping in a production environment.
Browse courses on
Log Shipping
Show steps
Show steps
Show steps
- Define the scope and objectives of the log shipping implementation.
- Identify the source and destination databases for log shipping.
- Configure the log shipping settings and monitoring mechanisms.
- Develop a testing and validation plan for the log shipping implementation.
Write a blog post on the benefits and limitations of Log Shipping
Show steps
Reinforce understanding of Log Shipping by explaining it to others
Browse courses on
Log Shipping
Show steps
Show steps
Show steps
- Identify the benefits and limitations of Log Shipping
- Write the blog post
Answer questions on a discussion forum related to Log Shipping
Show steps
Reinforce knowledge by sharing it with others and clarifying concepts
Browse courses on
Log Shipping
Show steps
Show steps
Show steps
- Find a discussion forum where people ask questions about Log Shipping
- Monitor the forum for questions related to Log Shipping
- Answer questions as you are able
Create a presentation on Log Shipping for a team meeting
Show steps
Communicate knowledge of Log Shipping to others and address potential questions
Browse courses on
Log Shipping
Show steps
Show steps
Show steps
- Identify the key concepts of Log Shipping
- Create slides that explain the benefits and limitations of Log Shipping
- Prepare to answer questions about Log Shipping
Career center
Learners who complete SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
A Database Administrator configures, maintains, and repairs databases. They ensure that data is securely stored, organized, and backed up. This course may be useful in a career as a Database Administrator by providing a foundation in log shipping, which is a technique used for high availability and disaster recovery. This course provides practical guidance on configuring and troubleshooting log shipping in SQL Server, which can be valuable knowledge for a Database Administrator who needs to ensure the reliability and performance of database systems.
Data Analyst
Data Analyst
A Data Analyst collects, analyzes, and interprets data to identify trends and patterns. They use this information to make recommendations and solve problems. This course may be useful in a career as a Data Analyst by providing a foundation in log shipping, which can be used to transport data between databases. This course covers how to prepare an environment for log shipping, configure log shipping, and troubleshoot common problems, which can be valuable knowledge for a Data Analyst who needs to manage and analyze data.
Data Architect
Data Architect
A Data Architect designs and implements data management solutions. They work with business stakeholders to understand data needs and develop data models. This course may be useful in a career as a Data Architect by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for a Data Architect who needs to design and implement high availability and disaster recovery solutions.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains software applications. They work with users to understand requirements and develop solutions. This course may be useful in a career as a Software Engineer by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers how to configure and troubleshoot log shipping, which can be valuable knowledge for a Software Engineer who needs to develop and maintain database applications.
Business Analyst
Business Analyst
A Business Analyst gathers and analyzes business requirements. They work with stakeholders to understand needs and develop solutions. This course may be useful in a career as a Business Analyst by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for a Business Analyst who needs to understand data management and disaster recovery solutions.
IT Manager
IT Manager
An IT Manager plans and manages the IT infrastructure of an organization. They work with users to understand needs and develop solutions. This course may be useful in a career as an IT Manager by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for an IT Manager who needs to understand data management and disaster recovery solutions.
Cloud Architect
Cloud Architect
A Cloud Architect designs and implements cloud computing solutions. They work with users to understand needs and develop solutions. This course may be useful in a career as a Cloud Architect by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for a Cloud Architect who needs to design and implement high availability and disaster recovery solutions.
Database Developer
Database Developer
A Database Developer designs and develops database applications. They work with users to understand requirements and develop solutions. This course may be useful in a career as a Database Developer by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers how to configure and troubleshoot log shipping, which can be valuable knowledge for a Database Developer who needs to develop and maintain database applications.
System Administrator
System Administrator
A System Administrator manages the computer systems of an organization. They work with users to understand needs and develop solutions. This course may be useful in a career as a System Administrator by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers how to configure and troubleshoot log shipping, which can be valuable knowledge for a System Administrator who needs to manage and maintain database systems.
Database Engineer
Database Engineer
A Database Engineer designs and develops database systems. They work with users to understand needs and develop solutions. This course may be useful in a career as a Database Engineer by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers how to configure and troubleshoot log shipping, which can be valuable knowledge for a Database Engineer who needs to develop and maintain database systems.
Network Administrator
Network Administrator
A Network Administrator manages the computer networks of an organization. They work with users to understand needs and develop solutions. This course may be useful in a career as a Network Administrator by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for a Network Administrator who needs to understand data management and disaster recovery solutions.
Information Security Analyst
Information Security Analyst
An Information Security Analyst protects the computer systems of an organization from unauthorized access. They work with users to understand needs and develop solutions. This course may be useful in a career as an Information Security Analyst by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for an Information Security Analyst who needs to understand data management and disaster recovery solutions.
Computer Systems Analyst
Computer Systems Analyst
A Computer Systems Analyst analyzes and evaluates computer systems. They work with users to understand needs and develop solutions. This course may be useful in a career as a Computer Systems Analyst by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers how to configure and troubleshoot log shipping, which can be valuable knowledge for a Computer Systems Analyst who needs to manage and maintain database systems.
Data Warehouse Architect
Data Warehouse Architect
A Data Warehouse Architect designs and develops data warehouse systems. They work with users to understand needs and develop solutions. This course may be useful in a career as a Data Warehouse Architect by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for a Data Warehouse Architect who needs to design and implement high availability and disaster recovery solutions.
Data Scientist
Data Scientist
A Data Scientist collects, analyzes, and interprets data to identify trends and patterns. They use this information to make recommendations and solve problems. This course may be useful in a career as a Data Scientist by providing a foundation in log shipping, which can be used to transport data between databases. This course covers how to prepare an environment for log shipping, configure log shipping, and troubleshoot common problems, which can be valuable knowledge for a Data Scientist who needs to manage and analyze data.
For more career information including salaries, visit:
OpenCourser.com/course/173zi9/sql
Reading list
We've selected 14 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping.
Covers a wide range of high availability and disaster recovery topics, including log shipping. It's a comprehensive resource for DBAs.
Save
Provides a comprehensive overview of SQL Server disaster recovery, including log shipping. It valuable resource for anyone who wants to learn more about disaster recovery in SQL Server.
Provides guidance on how to tune SQL Server 2012 for performance, including log shipping. It's a useful resource for DBAs who want to improve the performance of their log shipping environment.
Provides detailed instructions on how to administer SQL Server 2012, including log shipping. It's a helpful resource for DBAs who want to manage their log shipping environment.
Provides a comprehensive overview of SQL Server 2012 database administration, including log shipping. It's a valuable resource for DBAs who want to learn more about how to manage SQL Server databases.
Save
Provides a comprehensive overview of SQL Server T-SQL programming. It valuable resource for anyone who wants to learn more about T-SQL programming in SQL Server.
Provides a comprehensive overview of SQL Server security. It valuable resource for anyone who wants to learn more about security in SQL Server.
Save
Provides a comprehensive overview of SQL Server backup and recovery. It valuable resource for anyone who wants to learn more about backup and recovery in SQL Server.
Provides a good introduction to SQL Server 2012, including log shipping. It's a helpful resource for beginners.
Provides a comprehensive overview of SQL Server failover clustering, which related technology to log shipping. It valuable resource for anyone who wants to learn more about failover clustering for SQL Server.
Provides a comprehensive overview of SQL Server high availability, including log shipping. It valuable resource for anyone who wants to learn more about high availability for SQL Server.
Provides a comprehensive overview of SQL Server administration, including log shipping. It valuable resource for anyone who wants to learn more about SQL Server administration.
Provides a comprehensive overview of SQL Server troubleshooting, including log shipping troubleshooting. It valuable resource for anyone who wants to learn more about troubleshooting for SQL Server.
Save
Provides a comprehensive overview of SQL Server database administration, including log shipping. It valuable resource for anyone who wants to learn more about database administration for SQL Server.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/173zi9/sql
Share
Similar courses
Here are nine courses similar to
SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping.
SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring
OpenCourser.com/course/6ea1gy/sql
SQL Server: Understanding, Configuring and...
Most relevant
SQL Server Administration Part 3
OpenCourser.com/course/ser9ir/sql
SQL Server Administration Part 3
Most relevant
SQL Server: Upgrading and Migrating to SQL Server 2016
OpenCourser.com/course/5hbceq/sql
SQL Server: Upgrading and Migrating to SQL Server 2016
Most relevant
SQL Server: Installing and Configuring SQL Server 2016
OpenCourser.com/course/pz05gx/sql
SQL Server: Installing and Configuring SQL Server 2016
Most relevant
Real-time Web Server Log Analysis with SQL Server
OpenCourser.com/course/gyifvl/real
Real-time Web Server Log Analysis with SQL Server
Most relevant
Troubleshooting and Optimizing SSRS Reporting
OpenCourser.com/course/myxepl/troubleshooting
Troubleshooting and Optimizing SSRS Reporting
Most relevant
Monitoring, Troubleshooting, and Optimizing SharePoint 2016
OpenCourser.com/course/5omb8z/monitoring
Monitoring, Troubleshooting, and Optimizing SharePoint...
Most relevant
Advanced SQL Server Triggers: Optimizing and Troubleshooting
OpenCourser.com/course/9fh1d0/advanced
Advanced SQL Server Triggers: Optimizing and...
Most relevant
.NET 4 Logging Done Right: An Opinionated Approach Using Serilog 2
OpenCourser.com/course/r1a3xy/net
.NET 4 Logging Done Right: An Opinionated Approach Using...
Most relevant
Time
93 hours
Level
Introductory
Via
Pluralsight
Instructor
Glenn Berry
Language
English
Good to know
Develops knowledge and skills related to database management and administration
Teaches technologies and techniques that are in line with industry best practices
Provides in-depth coverage of SQL Server log shipping, including its concepts, configurations, monitoring, and troubleshooting
Suitable for individuals with varied backgrounds in database management, including DBAs, developers, and system administrators
Instructed by Glenn Berry, a recognized expert in the field
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser