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
]