what is diffence between replicaion and logshipping?
Answer / 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 |
What is difference between Triggers and store procedure?
How to run sql server 2005 books online on your local system?
Explain acid?
What is the difference between mysql and sql server?
How many cores do I need for sql server 2016?
Do you know what is normalization of database? What are its benefits?
What is use of except clause?
Can two tables share a primary key?
What is dirty page?
How to create a new table in a given schema?
Are connections to sql server encrypted?
What is the sql server agent?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)