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
What are the different ways you can create databases in sql server? : 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?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What authentication modes does sql server support? : sql server DBA
what is the use of ocr?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How to start SQL Server in minimal configuration mode?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what do you understand by flashback feature of oracle?
Explain materialized views and how they are used.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Query processing is slow(eg select query)how will u solve that