Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication in 2008R2 Expand / Collapse
Author
Message
Posted Wednesday, December 18, 2013 10:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, May 3, 2014 11:38 PM
Points: 14, Visits: 59
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?
Post #1524444
Posted Thursday, December 19, 2013 1:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1524481
Posted Thursday, December 19, 2013 3:33 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 18, 2014 3:47 AM
Points: 1,361, Visits: 15,263
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+difference+between+snapshot%2Ctransactional%2Cmerge+replications+in+sql+server+2008+r2&l=1

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/

Auditing is pretty expansive as a subject and you are better off reading and asking specific questions.
Post #1524503
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse