what is diffence between replicaion and logshipping?
- 1 Answers
- 3499 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
Explain how many types of relationship?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
Write SQL queries on Self Join and Inner Join.
How to end a stored procedure properly in ms sql server?
What is difference between Datepart() and Datename() in SqlServer?
How to stop a loop early with break statements in ms sql server?
can an automatic recovery be initiated by a user? : Sql server administration
what is the difference between delete table and truncate table commands? : Sql server database administration
If user is owning any SQL Objects, can we drop that user
Explain Geometry datatype in sql server 2008 with example
Indexes are updated automatically is the full-text index also updated automatically?
How to list all user defined functions in the current database?
When would you use the stored procedures or functions?
How to insert a new row into a table with "insert into" statements in ms sql server?
Can we write trigger for view?
