What is database replicaion? What are the different types
of replication you can set up in SQL Server?
Answer Posted / kishor
move/copy of the data from one server to another server is
call replication
types of replication
1.snapshot
2.merge
3.transactional
4.transactional with up-datable subscription(newly added in
sql server2005)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Where would you look for errors from the database engine?
what is the use of recording information about current session?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can you process messages in order asynchronously?
What are statistics, under what circumstances they go out of date, how do you update them?
What is transparent data encryption? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Explain materialized views and how they are used.
Why does Oracle not permit the use of PCTUSED with indexes?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you create a user-defined lock?