Answer Posted / Ashvani Deepak
"Log shipping provides several advantages in SQL Server. Here are a few key benefits:
1. Data Protection: Log shipping ensures that data is protected by maintaining a standby server with transaction logs, allowing for recovery in case of a primary server failure.
2. Redundancy and Disaster Recovery: Log shipping enables the creation of redundant databases, improving business continuity and disaster recovery capabilities.
3. Offload Reporting Load: Log shipping can be used to offload reporting loads from production servers by using the standby server for read-intensive activities.
4. Minimal Downtime: In case of a failure, switching over to the standby database allows for minimal downtime compared to other recovery methods.
5. Automatic Transaction Log Backup: Log shipping automates the process of transaction log backup on the primary server, reducing manual intervention and potential errors.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different SQL Server Versions you have worked on?
How raid can influence database performance?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How to convert character strings into numeric values?
Can sql servers link to other servers like oracle?
How can you append an identity column to a temporary table?
What is self contained sub query?
What is normalization and what are the advantages of it?
do you know how to configure db2 side of the application? : Sql server database administration
What is the primary use of the model database?
Why use identity in sql server?
Why and when do stored procedure recompile?
What is acid mean in sql server?
What are the different types of subquery?
