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 are the common performance issues in sql server?
How do I find the port number for sql server?
How to a Query to copy data from on table to another table.
What are page splits? : SQL Server Architecture
Which table keeps the locking information?
Which is faster statement or preparedstatement?
What are the five characteristics of good data?
Does order by actually change the order of the data in the tables or does it just change the output?
What is the beast way to write CTE in SQL Server ?
How do you delete a data source?
Explain how does the report manager work in ssrs?
Explain query editor regions
Oracle (3259)
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)