SQL Database Concepts Question:

Download Job Interview Questions and Answers PDF

Explain what is Log Shipping?

Basic SQL Server Interview Question
Basic SQL Server Interview Question

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 Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know what is a WITH(NOLOCK)?Explain what are the basic functions for master, msdb, model, tempdb databases?