Steve-3_5_7_9 (6/19/2013)
GilaMonster (6/18/2013)
Backup, copy, restore. Nothing different.2008 and 2008 R2 have the same compatibility level - 100.
What you want to updatestats in this case too or is it not applicable?
Not so much. The relational engine is near-identical between 2008 and 2008 R2. Something like 5 minor changes and that's all.
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