Hypercat (Deb)
asked on
SQL Server Express or Standard?
I've taken over administration of a network from another vendor. One of the many puzzling items I'm trying to figure out is a (somewhat) misbehaving SQL server. The server has 2 databases, one for Lexis-Nexis TimeMatters (law firm doc management program) and one for SoftPro (other law firm software). They're having some weird issues with TimeMatters that I'm trying to solve. In the process of trying to identify potential causes of problems, I'm trying to identify exactly what version of SQL they're running. Here's what I'm seeing that's confusing:
1. The SQL server instance indicates that it is running SQL Server Express - that is, both the Services panel and the Management Studio show "SQLExpress" as the instance name.
2. However, the server build number is 10.50.2500 which corresponds to SQL Server 2008 R2 SP1. Does SQL Server Express use the same build number? My searches aren't coming up with a separate document for SQL Express build numbers.
3. There is a database on this server which is 41GB in size. How can this database be running if the SQL version is in fact Express?
So, I'm wondering is it possible to upgrade a SQL instance from Express to Standard and still have an instance name of "SQLExpress"?
1. The SQL server instance indicates that it is running SQL Server Express - that is, both the Services panel and the Management Studio show "SQLExpress" as the instance name.
2. However, the server build number is 10.50.2500 which corresponds to SQL Server 2008 R2 SP1. Does SQL Server Express use the same build number? My searches aren't coming up with a separate document for SQL Express build numbers.
3. There is a database on this server which is 41GB in size. How can this database be running if the SQL version is in fact Express?
So, I'm wondering is it possible to upgrade a SQL instance from Express to Standard and still have an instance name of "SQLExpress"?
ASKER
Fantastische! So, here are the results, which tell me they're running SQL Server 2008 R2 Express Edition:
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
--//Your current Microsoft SQL Server information:
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
Product Version: 10.50.2500.0
Product Name: SQL Server 2008 R2
Product Level: SP1
Product Edition: Express Edition
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
Note, if you want to know information about CU, please read this KB below.
KB321185, <https://support.microsoft.com/en-us/kb/321185>
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
Support Lifecycle stage: Extended Support Phase. For additional information refer to
https://support.microsoft.com/en-us/lifecycle/search?sort=PN&alpha=SQL%20Server&Filter=FilterNO, and Q6, Q18
in the FAQ section of Support Lifecycle page at: https://support.microsoft.com/en-us/lifecycle#gp/lifePolicy
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
Full information:
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Intel X86)
Jun 17 2011 00:57:23
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (WOW64) (Hypervisor)
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
--//Recommended updates:
--### RTM -> QFE or GDR
--### SP -> QFE or GDR
--### QFE -> QFE
--### GDR -> GDR or QFE
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
Install the latest service pack: SP3, <https://support.microsoft.com/en-us/kb/2979597>
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
###### QFE branch updates
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
10.50.1790 (SQL Server 2008 R2 RTM QFE) http://support.microsoft.com/kb/2494086
10.50.2861 (SQL Server 2008 R2 SP1 QFE) http://support.microsoft.com/kb/2716439
10.50.4339 (SQL Server 2008 R2 SP2 QFE) http://support.microsoft.com/kb/3045312/en-us
10.50.6529 (SQL Server 2008 R2 SP3 QFE) http://support.microsoft.com/kb/3045314/en-us
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
Note, if you don't want to upgrade to latest service pack right now, we recommend you install the latest
Cumulative Update CU14 of SQL Server 2008 R2 SP1.
Install the latest Cumulative Update (CU) of SP1: CU14, <https://support.microsoft.com/en-us/kb/2868244>
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
--//You can upgrade to any of the following product(s):
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------
SQL Server 2012 Enterprise
SQL Server 2012 Business Intelligence
SQL Server 2012 Standard
SQL Server 2012 Web
SQL Server 2012 Express
So, back to my original puzzlement: How can they have a 41GB database when they're running SQL Express??
Also, there are 19 TimeMatters users, and the info above indicates only 5 licensed SQL users. Is that accurate?
--------------------------
--//Your current Microsoft SQL Server information:
--------------------------
Product Version: 10.50.2500.0
Product Name: SQL Server 2008 R2
Product Level: SP1
Product Edition: Express Edition
--------------------------
Note, if you want to know information about CU, please read this KB below.
KB321185, <https://support.microsoft.com/en-us/kb/321185>
--------------------------
Support Lifecycle stage: Extended Support Phase. For additional information refer to
https://support.microsoft.com/en-us/lifecycle/search?sort=PN&alpha=SQL%20Server&Filter=FilterNO, and Q6, Q18
in the FAQ section of Support Lifecycle page at: https://support.microsoft.com/en-us/lifecycle#gp/lifePolicy
--------------------------
Full information:
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Intel X86)
Jun 17 2011 00:57:23
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (WOW64) (Hypervisor)
--------------------------
--//Recommended updates:
--### RTM -> QFE or GDR
--### SP -> QFE or GDR
--### QFE -> QFE
--### GDR -> GDR or QFE
--------------------------
Install the latest service pack: SP3, <https://support.microsoft.com/en-us/kb/2979597>
--------------------------
###### QFE branch updates
--------------------------
10.50.1790 (SQL Server 2008 R2 RTM QFE) http://support.microsoft.com/kb/2494086
10.50.2861 (SQL Server 2008 R2 SP1 QFE) http://support.microsoft.com/kb/2716439
10.50.4339 (SQL Server 2008 R2 SP2 QFE) http://support.microsoft.com/kb/3045312/en-us
10.50.6529 (SQL Server 2008 R2 SP3 QFE) http://support.microsoft.com/kb/3045314/en-us
--------------------------
Note, if you don't want to upgrade to latest service pack right now, we recommend you install the latest
Cumulative Update CU14 of SQL Server 2008 R2 SP1.
Install the latest Cumulative Update (CU) of SP1: CU14, <https://support.microsoft.com/en-us/kb/2868244>
--------------------------
--//You can upgrade to any of the following product(s):
--------------------------
SQL Server 2012 Enterprise
SQL Server 2012 Business Intelligence
SQL Server 2012 Standard
SQL Server 2012 Web
SQL Server 2012 Express
So, back to my original puzzlement: How can they have a 41GB database when they're running SQL Express??
Also, there are 19 TimeMatters users, and the info above indicates only 5 licensed SQL users. Is that accurate?
ASKER
PS - is it because the log file is 40 GB but the database file is only 5GB, in which case I can probably greatly reduce the log file size!! I always thought the size limit included both.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great script for identifying the SQL version specifically. Thanks for your help!
Open in new window
Which I got from here:
https://gallery.technet.microsoft.com/Determining-which-version-af0f16f6