July 22, 2011 at 8:25 am
Hi,
We are upgrading from SS2K5 to latest version. Our environment is 64 bit with standard edition of all sql serves overall. At the moment log-shipping is working from central server to all different backup and reporting servers.
Now
Our production server will be SS 2008 R2 (and we have no problem moving that to Denali even in near future...)
Our backup and reporting servers at few locations, we still want to keep SS2K5 and on some other simple SS 2008.
Question is how to sync these different version of SQL Servers with production.
Log-shipping is not possible from higher version to lower...
Mirroring? but then reporting is not possible?
Replication from R2 to 2005 and 2008?
Manual data sync?
Suggest any other and advice which one is better.
Thanks.
July 22, 2011 at 8:57 am
Replication or manual are your only options. Mirroring won't work down-version.
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
July 22, 2011 at 10:45 pm
Hi,
Manal Sync is quite tedius and maintenance cost is very high.
Do you know, if replication from R2 to 2005/08 is really possible and will really work? and without any version problem like log-shipping?
What are the things to consider in such replication? i just want to sync once a day.
thanks.
July 23, 2011 at 3:50 am
It'll work, you just have to be sure you've got no 2008-specific features (no DATE, no TIME, etc)
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
August 5, 2011 at 3:16 am
Any joy?
Ok now we are moving to a next level. Now every server is either 2008 R2 OR 2008.
Do we now have any better choice?
August 5, 2011 at 3:22 am
For 2008, same thing. Replication or manual. It will work providing you use no features that aren't supported on the lower version.
For 2008 R2 to 2008 R2, depends on your requirements. Do you want the other server read-write? If so, replication. Read only and with a latency compared to production, mirroring with snapshot or log shipping.
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply