Replication of n(I mean numerous) databases in SQL2000.

  • Hello Experts,

    Can anyone explain me the process if it is possible for replication on n number of databases?

    My application creates at-least 50 databases per a working day. I would like to replicate the created database.

    All I need to know if it is really possible to replicate the database with numerous databases. If yes could you please post me the process?

    Thanks,

    Fred.

  • what do you mean by replicate?

    literally replication or just some form of copying the database to another server (so logship, full db restores, anything?)

    ---------------------------------------------------------------------

  • george sibbald (11/3/2011)


    what do you mean by replicate?

    literally replication or just some form of copying the database to another server (so logship, full db restores, anything?)

    @george sibbald Yes i need to know about replication process.

  • initial set up of replication is manual, you would never be able to keep up with 50 databases a day.

    You would also soon flood your network and have severe latency issues.

    ---------------------------------------------------------------------

Viewing 4 posts - 1 through 3 (of 3 total)

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