What Is Logshipping And Its Purpose?

1.	What Is Logshipping And Its Purpose?
Answer» In logshipping the TRANSACTIONAL LOG file from one server is AUTOMATICALLY updated in backup database on the other server and in the case when one server fails the other server will have the same DB and we can use this as the DDR (disaster recovery) plan. In logshipping the transactional log file from one server is automatically updated in backup database on the other server and in the case when one server fails the other server will have the same DB and we can use this as the DDR (disaster recovery) plan.

Answer»

In logshipping the TRANSACTIONAL LOG file from one server is AUTOMATICALLY updated in backup database on the other server and in the case when one server fails the other server will have the same DB and we can use this as the DDR (disaster recovery) plan.

In logshipping the transactional log file from one server is automatically updated in backup database on the other server and in the case when one server fails the other server will have the same DB and we can use this as the DDR (disaster recovery) plan.

Discussion

No Comment Found

Related InterviewSolutions

When I Run The Sql Server 2000 Setup, It Just Hangs. What Do I Do?
How Do I Perform An Unattended Install Of Sql Server 2000?
How Do I Install Only The Client Tools Of Sql Server 2000?
How Do I Determine How Many Instances Of Sql Server Are Installed On A Computer?
How Do I Find Information About The Install Locations For The Various Instances Running On A Computer?
What Are The Different Editions Available In Sql Server 2000?
Are There Any Preferred Steps That Need To Be Taken Care Of Before Starting The Installation Of Sql Server 2000?
What Is Awe?
What Is Dirty Page?
What Is Check-point?