What is database replicaion? What are the different types
of replication you can set up in SQL Server?
Answer Posted / swapna
Replication is the process of copying/moving data between
databases on the same or different servers. SQL Server
supports the following types of replication scenarios:
Snapshot replication
Transactional replication (with immediate updating
subscribers, with queued updating subscribers)
Merge replication
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Describe how to use linked server?
What is save transaction and save point?
what are constraints? : Sql server database administration
Which are the two editions in which SQL Azure database available?
What is difference between index and primary key?
What are the properties of the relational tables?
What is 3nf normalization form?
Explain the difference between cross join and full outer join?
How do you delete duplicate records in sql server?
Is BCNF better than 2NF & 3NF? Why?
Can I use sql azure as a backup with log shipping or database mirroring?
Where cross join is used?
What is the primary use of the model database?
Do you know what is a with(nolock)?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible