November 15, 2011 at 7:47 pm
Hello, I need to take a backup of my existing SQL Server 2008 R2 Express database and restore it to a SQL Server 2008 R2 Standard Edition database. I was wondering if there will be any issues with this.
November 15, 2011 at 9:37 pm
No you wont face any issue it will be restored properly
November 16, 2011 at 12:01 am
Edit: Express not Enterprise...
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
November 16, 2011 at 12:19 am
GilaMonster (11/16/2011)
Providing you're not using any of the persistent Enterprise-only features (TDE, Compression, partitioning), it will restore fine. If you're using any of those, the restore will fail at the end.
OP is planning to backup DB (Express Edition) & restore in Standard. He didn't mention Enterprise edition.
Also it's restore form Lowest Edition (Express) to Higher Edition (Standard). I don't see any issue in it.
November 16, 2011 at 5:55 am
Would I be able to install SQL Server 2008 R2 Standard Edition on the same server as the current SQL Server 2008 R2 Express Edition?
November 16, 2011 at 6:03 am
Yes. SQL Server support side-by-side installations of different versions / editions.
Considerations for Side-by-Side Instances of SQL Server 2008 R2 and SQL Server 2008
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply