Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffence between replicaion and logshipping?
- 1 Answers
- 4202 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
Where views are stored in sql server?
What are the steps you should follow to start sql server in single-user mode?
What are a scheduled jobs or what is a scheduled tasks?
What is resource governor?
What is clr ddl trigger?
Explain system scalar functions?
How many cores do I need for sql server 2016?
What is sleeping status in sql server?
How can you insert values in multiple rows using one Insert statement?
What is purpose of normalization?
Does a sql server 2005 select statement require a from?
What are the properties and different types of sub-queries?
What is the fillfactor concept in indexes?
What is buffer cash in sql server?
How to optimize stored procedure optimization?
