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 the difference between count and distinct count?
What is exclusive locks?
Explain what is lock escalation?
What is explicit cursors?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is Primary key and foreign key? Give an example
What is Transaction?
What is 1nf normalization form?
how can do you the system monitoring?
What stored by the tempdb ? : sql server database administration
How many full-text indexes can a table have?
What information is maintained within the msdb database?
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)