Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: Replication - can subscriber objects be pre-existing?

    My manager does not want to go through the process of moving 40 GB of data to the subscriber database over the network as would occur during the initialization phase of replication (exact method of replication has yet to be determined). The subscriber db is for Web Access and will be read-only. He wants to back up a db and use tapes to restore the db on the subscriber db server, and then activate replication. I have told him that you have to allow SQL Server to create the objects on the subscriber side and you have to allow SQL Server to control the data flow, that manually creating the objects on the subscriber side will not work. He says that I am incorrect.

    Who is right? I haven't been able to find an answer from the Microsoft site and news groups.


  2. #2
    Join Date
    Jan 2004
    In a large office with bad lighting
    I hate to be the bearer of bad news for you, but your manager is correct in this instance.

    Here's the link to get you started:

    It really does speed things up!


    -- This is all just a Figment of my Imagination --

Posting Permissions

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