1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What is database replicaion? What are the different types
of replication you can set up in SQL Server?

Question Posted / guest


What is database replicaion? What are the different types of replication you can set up in SQL Ser..

Answer / 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

More DB Administration Interview Questions

how can you initialize log miner?

0 Answers   Oracle,

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

How many packages we have in db

1 Answers   Tesco,

What does coalescing a tablespace do?

1 Answers  

Explain the use of table functions.

1 Answers  




What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

how can you process messages in order asynchronously?

0 Answers   Oracle,

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

Explain about your sql server dba experience? : sql server DBA

0 Answers  

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories