Post reply

Database replication

  • January 29, 2013 at 12:38 pm

    #267826

    Hello folks - new to the forum and relatively new to SQL 2008.

    I have been given the task of trying to replicate a rather large database which is stored on a sever running SQL Server 2005 to a server running SQL Server 2008 R2. We are trying to make the destination database as 'real time' as possible.

    When I try to initiate replication is basically locks up the database and the users are unable to do anything. I have done research in regards to optimizing but still no go.

    I cannot use the Copy DB function in 2005 due to the destination server being 2008 and from what I have read mirroring is not an option due to the fact it locks up the destination DB.

    Any help or suggestions on how to accomplish this task would be greatly appreciated.

    Thanks in advance !

  • January 30, 2013 at 2:04 am

    #1582515

    You could look at initialization from backup, instead of from snapshot.

    http://msdn.microsoft.com/en-us/library/ms147834%28v=sql.100%29.aspx

  • January 30, 2013 at 6:19 am

    #1582579

    hi ,

    1.first enable tcp\ip port numbers

    2.disable firewall

    3.take backup and restore in subscriber this will be better for when we have large database .

    Thanks&Regards
    AJAY REDDY.L

  • January 30, 2013 at 7:18 am

    #1582600

    there are several option available.

    like logshipping ,mirroring ,replication .

    database replication has to done when some table,sp are critical and you want to replicate then to staging database.

    or you want entire database to replicate you can use logshipping or mirrioring .

    in logshipping, destination database can be use as stand by -only in readable form

    in Replication :if want to replication of huge tables then create one publisher for one table .And for small tables you

    can create single publisher and many small tables under that. this will work well

    and both database accessible to user.

  • January 30, 2013 at 10:49 am

    #1582668

    What is a "relatively large" database? Can you give us an actual size? I want to rule out other problems... Anthony's suggestion of initializing from a backup would be the best way if it was really big. The other option is to add articles 1 at a time and snapshot each time one is added.

    Jared
    CE - Microsoft

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

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