Answer / 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.

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

---

What is BLOCK statements in SQL?

1 Answers   HCL,

---

What is the difference between for auto and for nested?

1 Answers  

---

What is a Stored Procedure?

8 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

Do you know what are acid properties?

1 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

What is an index in a database?

1 Answers  

---

what is the difference between delete table and truncate table commands? : Sql server database administration

1 Answers  

---

Is it ok to shrink transaction log?

1 Answers  

---

i want table name basis on column name.

5 Answers  

---

What does the update command do?

1 Answers  

---