July 13, 2008 at 10:44 pm
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
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
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
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 ...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply