Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffence between replicaion and logshipping?
- 1 Answers
- 4111 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
Do you know clustered and non-clustered index?
What are a scheduled jobs or what is a scheduled tasks?
What it means to be triggered?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What are scalar functions?
What is the full form of dql?
List some advantages and disadvantages of stored procedure?
What is application role in sql server database security? : sql server security
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
Can we add an identity column to decimal datatype?
How to count groups returned with the group by clause in ms sql server?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What different steps will a sql server developer take to secure sql server?
What is policy management?
