How to Upgrade from SQL Express to SQL Enterprise Edition

News

About Me:
I am a 26 year old female SharePoint Enthusiast. I work for B&R Business Solutions from my home in Olathe, KS. I have been working with SharePoint since I attended the Portal University in 2005. I hold a BA in Computer Science from the University of Missouri - Kansas City. I love playing Rockband, organizing user group meetings, working with MOSS, attending Code Camps as a speaker, and having bizarre conversations about geek things with cool people. If you have any comments or questions fill out the contact form and I will try my best to help.

My Stats

Posts - 136
Comments - 162
Trackbacks - 0

Twitter

MossLover Form mostly done a couple bugs to work out...Time to end for the day...My eyes hurt and I need to eat. about 4 hours ago

MossLover I am going to continue accepting submissions for SP Saturday KC until January 16th. about 6 hours ago

MossLover I'm hardcore tweeter rolling in at #2000 :) about 6 hours ago

MossLover @bishopd Stop tempting me to go to Borders...I just bought two new Expression Blend 2.0 books. about 7 hours ago

MossLover 6 1/2 hours of coding today so far...Going to go until I finish this form, then tommorow look at some style fixes and createa more webparts about 7 hours ago

MossLover I'm not being a jerk right now...I just turn off twitter when I need to concentrate, so if anyone wants to contact me I'll respond later. about 11 hours ago

MossLover Ok I have a form and some other webparts to create today, plus a little spacing to fix...Time to get it done. about 13 hours ago

MossLover We have 0 SP Saturday KC speaking slots left...Thanks everyone who submitted and is heliping out with the event! about 13 hours ago

MossLover Keep getting work emails...Phone keeps vibrating and sleep is not coming. about 1 day ago

MossLover Going to bed...Not getting up until 11 am I bet...Then doing the same thing again staying up until 3/4 am... about 1 day ago

Post Categories

Blogs on SharePoint

How to Upgrade from SQL Express to SQL Enterprise Edition

I was using a VPC today, so that I could restore our content database and keep a copy of our SharePoint instance for development. I noticed that SQL Express only allows about 3-4 gb of data in a database. That wouldn't work out considering our Content DB is 21.9 GB. So I need to find a way to upgrade the SQL Server instace to SQL Enterprise Edition. I did some research and some tweaking and figured it out. If you open up a command prompt window and type in this information:
start /wait C:\setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=NameOfServerInstance UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
Unfortunately, if this is a production server you may experience some down time, so plan accordingly with your maintenance schedule. If anyone has any comments or questions please let me know.

posted @ Tuesday, June 10, 2008 11:20 AM | Filed Under [ MOSS .Net ]

Comments

No comments posted yet.

The Guide of a MOSSLover

Becky Isserman's Blog

News

My Stats

Twitter

Tag Cloud

Recent Comments

Recent Posts

Archives

Post Categories

Blogs on SharePoint

Other Blogs

Resources on Sharepoint

Stuff

How to Upgrade from SQL Express to SQL Enterprise Edition

posted @ Tuesday, June 10, 2008 11:20 AM | Filed Under [ MOSS .Net ]

Comments