March 30, 2011 at 9:30 am
I have the following setup and have questions regarding log shipping from SQL2008R2 to SQL2008:
SQL2008R2 Instance SQL1 - Source Data
SQL2008 Instance SQL2 - Log Shipped Data
Are there any known issues with log shipping data from SQL2008R2 to SQL2008?
The reason for the second server being on SQL2008 (not R2), is that I have to also use this instance for BizTalk 2009 databases.
Thank you,
March 30, 2011 at 10:22 am
Are you successfully doing this? I wouldn't think it would work because you typically cannot do a restore to a lower version of the product. I'm not sure how it works with 2008 R2 to 2008 and I don't have instances to play with.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 30, 2011 at 10:37 am
mkgrayson (3/30/2011)
Are there any known issues with log shipping data from SQL2008R2 to SQL2008?
Yup, just one.
It won't work.
You cannot restore a 2008 R2 database onto SQL 2008. Hence you can't even start the log shipping (which requires the restore of a full backup). Even if you could get a DB there somehow, the log backup restores would fail for the same reason.
Log shipping SQL 2008 - SQL 2008 R2 works, but I don't think it's supported other than in an upgrade situation
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2011 at 10:42 am
Thanks for clearing this up Gail. The whole R2 naming is what causes the confusion I think.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 30, 2011 at 10:54 am
Jack Corbett (3/30/2011)
The whole R2 naming is what causes the confusion I think.
Way too much. It's a separate version of SQL, just like 2008 and 2005 and the same upgrade/downgrade rules apply
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2011 at 12:38 pm
Well, you MVPs need to stress to MS how confusing this R2 naming scheme is to everyone, and how they need to stop it.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
March 30, 2011 at 1:50 pm
WayneS (3/30/2011)
Well, you MVPs need to stress to MS how confusing this R2 naming scheme is to everyone, and how they need to stop it.
You think it hasn't been mentioned a few (thousand) times?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2011 at 3:54 pm
GilaMonster (3/30/2011)
WayneS (3/30/2011)
Well, you MVPs need to stress to MS how confusing this R2 naming scheme is to everyone, and how they need to stop it.You think it hasn't been mentioned a few (thousand) times?
Well, then it sounds like you need to bring some of those sharp things with you the next time... maybe that will get their attention!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply