From the course: SQL Server 2016: Administer a Database Infrastructure
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Configure log shipping - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Configure log shipping
- [Instructor] To enable log shipping on a primary database, we need to have access to two instances of SQL Server. For the purposes of this demonstration, I'm going to be using two instances on the same machine, but that largely defeats the purpose of log shipping. Ideally, you'd want to have them on two separate machines that can see each other on the network and have access to a shared storage location. To take a look at log shipping, I'm going to create a new database here called KinetecoIncDB. Then we'll create a table called NewProducts. I'm going to insert some records into it and I'm just going to pull data out of the WideWorldImporters database. That'll insert 74 rows. And if I select everything out of the NewProducts table, we'll see that data here. I can also take a look in the bottom right-hand corner to verify that I've got 74 rows of data. Now, log shipping has two prerequisites that we need to set up before we get started. First, the database needs to be in the full or…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.