Results 1 to 3 of 3

Thread: snapshot

  1. 03-29-2005, 12:36 AM #1
    minthiha
    minthiha is offline Registered User
    Join Date
    Feb 2005
    Location
    yangon
    Posts
    6

    Lightbulb snapshot

    I just want to know about snapshot replication that how much data can hold when network is normal transaction? if you know exactly please tell me.
    Reply With Quote Reply With Quote
  2. 03-29-2005, 08:25 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Snapshot replication

    1. Snapshot agent
    a. Put shared lock on all tables
    b. Generate schema of all tables
    c. Exports all the data as files to shanpshot folder

    2. Distribution Agent
    a. create table using the schema generated.
    b. import the exported data to the subscriber.

    Are you asking the limitation of snapshot replication or how long it will take?
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 03-29-2005, 10:20 PM #3
    minthiha
    minthiha is offline Registered User
    Join Date
    Feb 2005
    Location
    yangon
    Posts
    6

    limitation of snapshot

    I would like to know the limitation of snapshot replication and
    how difference with other replication.
    Thanks for your reply.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules