Post reply

Lots of questions - Delete my pain

  • May 18, 2005 at 5:02 am

    #102534

    Hello guys!!

    I'm a new SQL Developer and for that forgive me my stupid questions and please understand my desperation.

    Forgive me too my poor english.

    My questions are:

    1. There are 4 ways of implementing replication: Wizards and Properties, Programming Interfaces, Scripting of system stored procedures, and Windows Synchronization Manager. I use Wizards and properties. Do I loose performance and/or capacities?

    2. I can make replication work when my pc - Publisher, belongs to the same domain of the other server - Subscriber. When is not in domain, i can not. This is normal?

    3. I have two remote servers: Server_S and Server_C. I want transactional replication. Server_C is the Subscriber and has SQL Server 2000. I want Server_S to be Publisher. What i need to install in Server_S? I tried MSDE but in this case Server_S has to be Subscriber... What is the best solution? I'm limited by S.O. of Server_S - Windows XP Pro and i should avoid another license.

    4. The files in the snapshot folder are automatically deleted?

    Thanks

    I hope one day answering the questions of others beginners developers.. in this time i hope be an expert in replication

    Cláudia from pt

     

    Regards,

    Cláudia Rego

    www.footballbesttips.com

  • May 19, 2005 at 5:05 am

    #559805

    1: performance is the same, but some functionality is only available by replication scripts and not the GUI.

    2: Have a look at : http://www.replicationanswers.com/InternetArticle.asp

    3: You can't - you'll need Standard (or workgroup) for this, and hence a server OS. If it is just for your development, you could use Developer edition on XP.

    4: The distribution cleanup agent will remove them once all named subscribers have picked them up. If not all named subscribers pick them up, they're removed at the end of the transaction retention period. If you have anonymous subscribers, they're always left until the end of the retention period.

    HTH,

    Paul Ibison, SQL MVP

     


    Paul Ibison
    Paul.Ibison@replicationanswers.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply