Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffence between replicaion and logshipping?
- 1 Answers
- 4279 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 do you mean by recursive stored procedure?
When to use null data driven subscription?
What is an indexing technique?
what are isolation levels? : Sql server database administration
What are the steps you must follow to hide sql server instances?
How we create SQL Server 2005 Reporting Services ? Give me Sample
Where the sql logs gets stored?
What is transaction server explicit transaction?
What is the difference between functions and stored procedures?
How can you control the amount of free space in your index pages?
What is bulkcopy in sql?
How to select true false based on column value in sql server?
What is the default schema of your login session in ms sql server?
Does partitioning ssd reduce performance?
How to create new databases with "create database" statements?
