Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffence between replicaion and logshipping?
- 1 Answers
- 4174 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
What is xdr?
How to write an inner join with the where clause in ms sql server?
Do you know how to make remote connection in database?
Explain log shipping and mention its advantages.
How does recursive cte works in sql server?
What are pessimistic lock and optimistic lock?
What is a data source file?
What are sub reports?
Explain the third normal form(3nf)?
What is indexed view? How to create it?
How can we remove orphan records from a table?
How to generate create procedure script on an existing stored procedure?
What is the main difference between ‘between’ and ‘in’ condition operators?
How do I create an extended event in sql server?
What are the 2 types of classifications of constraints in the sql server?
