what is diffence between replicaion and logshipping?
- 1 Answers
- 3774 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to create user messages with print statements in ms sql server?
What are the three different part of rdl file explain them?
what is sql server? : Sql server database administration
What is purpose of normalization?
What are different types of collation sensitivity?
How to rebuild indexes with alter index ... Rebuild?
What is a dbms wizard?
Can a trigger be created on a view?
What is sql injection and why is it a problem? : sql server security
What are the different editions available in sql server 2000?
How many types of stored procedures are there in sql server?
What are the operating modes in which database mirroring runs?
What are the advantages to use stored procedures?
What is an example of a foreign key?
What is indexed view?
