We've been on sql 2014 for a while--ever since it was supported for CM. We're already looking at when we can get to SQL 2016. But at a minimum; sql 2014, whatever the latest SP and CUs are.
On Fri, Aug 5, 2016 at 4:42 PM, Art Flores <[email protected]> wrote: > SQL Server 2014 Standard Edition with SP2 .ISO was made available last > month. More info on SQL Server 2014 build versions here: > > > > https://support.microsoft.com/en-us/kb/2936603 > > > > *From:* [email protected] [mailto:listsadmin@lists. > myitforum.com] *On Behalf Of *Heaton, Joseph@Wildlife > *Sent:* Friday, August 05, 2016 3:48 PM > *To:* '[email protected]' <[email protected]> > *Subject:* [mssms] SQL upgrade > > > > We have 2008R2 at the moment, installed on my Primary site server. I want > to upgrade: > > > > 1) 2012, or 2014? (I’m thinking 2014, just for future proofing) > > 2) Any major gotchas? > > a. I’m planning on doing a full backup of the database first, and > this is also a VM, so there will definitely be a snapshot before doing the > upgrade. > > > > Joe Heaton > > Information Technology Operations Branch > > Data and Technology Division > > CA Department of Fish and Wildlife > > 1700 9th Street, 3rd Floor > > Sacramento, CA 95811 > > Desk: (916) 323-1284 > > > > Every Californian should conserve water. Find out how at: > > [image: SaveOurWater_Logo] <http://saveourwater.com/> > > SaveOurWater.com <http://saveourwater.com/> · Drought.CA.gov > <http://drought.ca.gov/> > > > > > > -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org
