Solved

Some Qouestions about SQL server 2005 Replication . P1

Posted on 2009-04-04
2
266 Views
Last Modified: 2012-05-06
Hi
1- If I have a Tranasactional replication Is Snapshot Folder is required after all subscriber intilize? In other word ... is Snapshot Folder which contains (*.bcp,*.idx,....files )  is used by distributor or subscriber after all subscriber initilized with this snapshot ?
2- in Tranasactional replication , when i create new Publication the wizard provide me with with 2 option one of them to
"schedule the snapshot agent to runat the following times" what the benifit /needs of scheduling to creating snapshot ?
0
Comment
Question by:ali_alannah
2 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 24067196
1.  The folder is used to the distributor to take the snapshot data and move it and apply it to the subscriber.
2.  Right, and the other option is for it to always run.  Sometimes you're in a situation where you don't want your data replicated, or only want it replicated at night.  This is what the option you mentioned is for.
0
 

Accepted Solution

by:
ali_alannah earned 0 total points
ID: 24067244
Hi chapmandew:
it seems ther's a misunderstanding because my bad english
you said
1.  The folder is used to the distributor to take the snapshot data and move it and apply it to the subscriber.
my question is this folder are using for one time for first time to intialize the data "restore the date" on the subscriber , after that no need for it .. is this right?
2.  Right, and the other option is for it to always run.  Sometimes you're in a situation where you don't want your data replicated, or only want it replicated at night.  This is what the option you mentioned is for.
the option i mentioned related to SNAPSHOT agent which dont track any changes on the data ,  
you said "or only want it replicated at night." you talk about a transaction "changed data" which the napshot not concern
Kindly am waitting for you replay as sson as possible
 
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PERFORMANCE OF SQL QUERY 13 65
SQL Trigger selecting another database 4 33
Truncate vs Delete 63 101
sql query help 2 44
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now