We have installed SQL Express edition on our production server(SQL SEVER 2005). we need to upgrade to Work group edition.
Is it possible to upgrade the production SQL Server to the work group edition? What are the risks?
Nov 10, 2009 at 12:27 PM
Nov 10, 2009 at 12:49 PM
Melvyn Harbour 1 ♦♦
Yes you can upgrade - have a detailed recovery plan in case it goes wrong which should include backups and a maintenance window when you can take the databases down.
Nov 10, 2009 at 12:48 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Nov 10, 2009 at 12:27 PM
Seen: 1472 times
Last Updated: Nov 10, 2009 at 12:49 PM
how to identify sql server deprecated features of 2000 and 2005 in 2008 server
Extremely horrible Linked server performance after upgrade to 2008
Upgrade 2005 to 2008
Can we upgrade sql server 2005 to sql server 2012?
Cost-Benefit Analysis for SQL Server Storage upgrade
Should somebody not yet on SQL 2008 wait for SQL 2008 R2, since it's near release?
Is this normal for indexes from SQL 2000 to SQL 2005?
SQL Server 2005 Enterprise edition to SQL Server 2008 Developer edition
SSIS: External columns for a component "" are out of synchronization with the data source columns
SqlServer 2005 CU7 Patching