SQL server detection doesn't work for SQL 2012

Mar 4, 2013 at 1:15 PM
The Is-SnapShotCompatible function needs updating to support SQL 2012.

My SQL server is Version 11.0.3000.0, Edition "Enterprise Evaluation Edition (64-bit)". It should support snapshots, but the script only looks for versions 9 and 10.

The statement "$sqlEdition.Contains("Enterprise Edition")" also won't match "Enterprise Evaluation Edition"...though that's not such a bit deal, don't be using the evaluation version in production.
Coordinator
Mar 4, 2013 at 8:21 PM
Edited Mar 4, 2013 at 8:22 PM
Thanks for input

Already added in version 2.4 which is due for release soon.

Darren
Apr 9, 2013 at 1:34 PM
Will SharePoint 2013 support be coming in another major release or might it be also handled at that time?

I scanned the script and it looks like the hive14 backup, SP1 check, and the SQL 2012 "detection" are the major work areas (I assume the appcmd.exe commands will still work on Server 2012).
Jan 30, 2014 at 11:10 AM
Hi,

You have to add this snippet of code:
          11
            {       
                if (($sqlMinorVersion -eq 0) -and ($sqlBuild -ge 2100))
                {
                    $Version = "SQL Server 2012 RTM or Higher"
                    $IsValidSqlVersion = $true
                }   
            }
After the line 809.