Monday, March 12, 2012

Log Shipping From SQL 2000 to SQL 2005, Can it be done?

Hello,

Is it posible to set up log shipping from SQL 2000 to SQL 2005 and if so how? Where is there some documentation on how this can be done?

Sorry, but that can't be done. Basically, both ends of a log shipping configuration need to be the same major versions...see the following topic:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=189557&SiteID=1

And, for more information, see these sections on msdn:

http://msdn2.microsoft.com/en-us/library/ms188297(SQL.90).aspx

Each also discuss what you could possibly do instead.

HTH,

No comments:

Post a Comment