SQL Database Concepts Question: Download Questions PDF
Tell me what is log shipping?
Answer:
-SQL has introduced Log Shipping feature to synchronize the Distributed Database Server. Synchronize the database by copying Transaction logs, Backing up, Restoring data. SQL Server Job Agents is used to make these processes automatic.
-In the case of failure the Log Shipping will not transfer the server. That means it will not redirect your application to other server. This has to be done manually.
-Log shipping synchronizes the database only. The main functions of Log Shipping are as follows:
1. To Back up the transaction log of the primary database
2. To Copy the transaction log backup to every secondary server
3. To Restore the transaction log backup on the secondary database
-In the case of failure the Log Shipping will not transfer the server. That means it will not redirect your application to other server. This has to be done manually.
-Log shipping synchronizes the database only. The main functions of Log Shipping are as follows:
1. To Back up the transaction log of the primary database
2. To Copy the transaction log backup to every secondary server
3. To Restore the transaction log backup on the secondary database
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can you explain what is SQL Server English Query? | Explain the rules for designing Files and File groups in SQL Server? |