SQL Database Concepts Question:

Explain what is Log Shipping?

Tweet Share WhatsApp

Answer:

Log shipping enables high availability of database. It the process of shipping the transaction log to another server. It copies the replica of the database. Both the databases are in synch. In case of failure of primary server or database, the secondary server can be used. In this process, another server called as monitor that tracks the history and status of backup and restore operations.

Download Basic SQL Server PDF Read All 113 Basic SQL Server Questions
Previous QuestionNext Question
Do you know what is a WITH(NOLOCK)?Explain what are the basic functions for master, msdb, model, tempdb databases?