Log shipping between instances

[djj55]

Hello, I know you can log ship between 2000 and 2008 but can you go the other way.

What about replication?

We are discussing what order to upgrade our servers and would like to know if we upgrade our primary before our secondary can I still log ship to it? (Secondary being used for several things.)

Thank you,

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[mrdenny]

No you can't log ship from SQL 2008 to SQL 2000.

Yes you can replicate data from SQL 2008 to SQL 2000.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[djj55]

Thank you

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!