December 18, 2013 at 10:29 pm
hi....
1. what is diff b/w snapshot,transactional,merge replications in sql server 2008 r2.
2. what is exactly auditing is the server level or database level?
December 19, 2013 at 1:42 am
Depends on the various business requirement replication can be set up between Publisher and subscriber. It can also support heterogeneous environment.
Refer following BOL topic for further detail and understanding. It also contains detail explation with sceniro.
http://technet.microsoft.com/en-us/library/ms152531(v=sql.105).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 19, 2013 at 3:34 am
gaddamshiva (12/18/2013)
hi....1. what is diff b/w snapshot,transactional,merge replications in sql server 2008 r2.
2. what is exactly auditing is the server level or database level?
http://lmgtfy.com/?q=what+is+sql+server+auditing+at+the+database+or+server+level&l=1
Sorry. Both of those questions are pretty general.
Replication.
Snapshot: refreshes the whole subscription on a schedule. Not suitable for large publications
Transactional: Can be near realtime as it trickles the transactions regularly. Generally read only but they're are updateable versions
Merge: Can be similar to transactional and close to real time. Allows for updates at both publisher and subscriber.
Consider reading the stairway articles for more info. They can be found here:
http://www.sqlservercentral.com/stairway/72401/[/url]
Auditing is pretty expansive as a subject and you are better off reading and asking specific questions.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply