Post reply

Is it possible to set replication between SQL 2005 & 2000 Servers?

  • July 13, 2008 at 10:44 pm

    #189517

    Hi

    Is it possible to set replication between SQL 2005 & 2000 Servers?

    What difficulties will i have to face if i try this?

    Muralidaran r

  • July 14, 2008 at 2:28 am

    #842238

    Yes it is, you will however be limited to the abilities SQL 2000 in terms of replication. For example i think log shipping is not available in 2000.

    Cheers.

  • July 14, 2008 at 2:57 am

    #842241

    Hi there, yes you can do it you will have to set the db to 2000 compatibility in 2005 and yes log shipping is available in 2000 that is where it started.

    you would probably be better off migrating to 2005 altogether though.

    Regards,

    Terry

  • July 14, 2008 at 3:31 am

    #842251

    My bad ... was pretty sure I read somewhere that log shipping could not be used with 2005 / 2000 replication.

    In any case books online lists all the details ...

    http://msdn.microsoft.com/en-us/library/ms143241.aspx

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

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