question

anayak001 avatar image
anayak001 Suspended asked

Log shipping between SQL 2000 and SQL 2008

is it possible to logshipping sql 2000 to sql 2008?
sql-server-2008sql-server-2000log-shipping
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jhowe avatar image jhowe commented ·
SQL backup pro supports log shipping from 2000 to 2008 apparently. I'm just looking into setting up log shipping at the moment
0 Likes 0 ·

1 Answer

·
WilliamD avatar image
WilliamD answered
Yes it is possible to run log shipping from SQL 2000 to SQL 2008. Just be aware that the other way is not possible. I would check for deprecated features/data types that may have been dropped in 2008 that were still valid in 2000. I guess there isn't anything terrible there, but cannot guarantee that as I haven't touched SQL 2000 in years.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.