SQL Database Concepts Question:
Download Job Interview Questions and Answers PDF
Explain what is Log Shipping?
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 Question | Next Question |
Do you know what is a WITH(NOLOCK)? | Explain what are the basic functions for master, msdb, model, tempdb databases? |