From the course: SQL Server 2022 Administration
Join today to access over 24,700 courses taught by industry experts.
Setup SQL Server Log shipping - SQL Server Tutorial
From the course: SQL Server 2022 Administration
Setup SQL Server Log shipping
In this lesson, we're going to go ahead and configure SQL Server Log Shipping. Now, this is something that people have been doing in SQL Server back -- many versions before it was an official feature because all we're really doing here is backing up a database from one server and restoring it to another. So when you restore a database, you can leave it in that recovering state. So I can continue to apply additional transaction log backups to it and continue to bring it up to date. So all we're doing with log shipping is we're leaving a database on a secondary server in that restoring state and it's just going to continually get the next transaction log backup from the primary server. So we take a transaction log backup, we ship it over here and we restore it to that database, hence transaction log shipping. So in a version of SQL Server years back, they decided to make this a feature and help you automate it rather than having to have your admin go in and create all the jobs to do all…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
