SQL Server Log Shipping -2

Hi,

In this article, I will continue to explain you about Log Shipping technology in SQL Server.

 

Read previous article before this.

 

Now let’s install Log Shipping via a sample database and visually explain the implementation of Log Shipping. Before starting installation, we can determine the pre-requirements for Log Shipping as follows.

 

  1. Recovery Model must be either Full or Bulk-Logged in the primary database.
  2. There must be a shared folder on the Primary server that the Secondary Server can access. Transaction log backups will be kept in the shared folder and the secondary server will copy these files and restore the backups.
  3. The user to perform the Log Shipping configuration must be sysadmin role.

 

The SQL Server Instance and the status of the Log Shipping process are as follows.

Log Shipping işlemini gerçekleştireceğimiz SQL Server Instance ları ve statüleri aşağıdaki gibidir.

Primary (Production) Database: MYTESTINSTANCE

Secondary (Standby) Database: TEST2008R2

 

After complete the requirements,  now start installation of Log Shipping. I’m creating a sample database and table called TestDatabase, TestTable.

 

1

 

 

Insert sample data into the TestTable table as below for log shipping testing.

2

 

Before starting installation of Log Shipping, we will follow the steps as following.

  1. Take Full Backup of the primary database and restore this backup on the Secondary Server in NoRecovery Mode.
  2. Perform the Log Shipping Configuration.

 

Take full backup of primary database like following.

3

 

 

Restore this backup on the Secondary Server in NoRecovery Mode.
6

 

 

Take Transaction log backup of primary database like following.

4

 

Restore this backup on the Secondary Server in NoRecovery Mode.

7

 

I will explain the configuration of Log Shipping in the Next article.

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.