July 28, 2010 at 10:56 am
I have a Windows Small Business Server 2008 currently running SQL Server Express 2008 R2.
Ive poked around here, ms, and google, but haven't found a definitive answer.
Can I seamlessly upgrade (or run side-by-side) SQL Server 2008 R2 Standard Edition for Small Business.
Thanks,
Karl
July 28, 2010 at 3:35 pm
You can do either.
Installing a full Standard version of SQL Server 2008 R2 on the same machine will work fine. You will have two instances and each will behave based on its edition limitations.
You can also migrate the database directly over to the standard edition by detaching it, moving the file to an appropriate location and attaching it to the standard edition. Any upgrades will be handled automatically. However, this adds functionality so it is harmless/painless.
However, you typically cannot move down the edition ladder if you use any of the features not included in the lower edition.
July 28, 2010 at 4:05 pm
If you weren't running SBS, I would say yes. Previous experience with SBS can cause problems because it is extremely finicky.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 28, 2010 at 4:59 pm
CirquedeSQLeil (7/28/2010)
If you weren't running SBS, I would say yes. Previous experience with SBS can cause problems because it is extremely finicky.
And that is really the crux.
I know the SBS versions are fairly locked down, but am not clear on this particular point.
If it was just Server 2008 it would clearly be supported.
August 2, 2010 at 10:21 am
MS just told me, basically, that the only 2008 R2 edition that will run on SBS2008 is Express.
August 3, 2010 at 9:46 am
That is good to know. Thanks for posting back your findings.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply