what is diffence between replicaion and logshipping?



what is diffence between replicaion and logshipping?..

Answer / hari

Log shipping is the different than the Replication .

Logs can be shipped to stand by server. where the database
should be in non-recovery or standby mode.you can you have
stand by server ready when failure of primary server occurs
or you can even use standby server for read only adhoc
queires by users in your organization to distribute load
and also use the same server in event of main server failure

As per replciation there are 3 types of repliciation .
Depending on the transcations being performed and the
requirement you implement it.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is ACID Property of Transaction?

10 Answers  


What are the triggers in sql?

0 Answers  


What is the difference between a function and a stored procedure?

0 Answers  


What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,


How many index keys possible for a table

6 Answers  






What is the difference between TRUNCATE and DROP?

0 Answers  


What are the limitation of the Online Index Rebuild Operation?

1 Answers  


what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,


What is index fragmentation in ms sql server?

0 Answers  


Difference between aggregate functions of sql?

0 Answers   EXL,


Can I delete event logs?

0 Answers  


How to download microsoft sql server 2005 express edition?

0 Answers  


Categories