SQL Express is a free version of SQL from Microsoft that comes with some limitations. It can utilize a maximum 1 GB of RAM per instance, the maximum database size is 10 GB, and there can be a maximum of 50 instances per server. SQL Express is limited to either 1 socket or 4 cores, so if you need a more powerful environment, you may consider upgrading to a higher SQL Server edition.
The following upgrade process is very similar for the SQL Server Express 2008 R2 and later versions. In order to upgrade, you must temporarily stop the ESMC Server service and create a full database backup in case the upgrade process does not finish properly. To check the supported version and edition upgrade options, see the SQL Express vendor documentation.
C:\P
rogram Files\Microsoft SQL Server\MSSQL.n\MSSQL\Log\ERRORLOG
and ERRORLOG.n
The version of MS SQL Server is specified in the first rows of the log.Figure 1-1
Figure 1-2
Figure 1-3
Figure 1-4
Figure 1-5
Figure 1-6
Figure 1-7