October 2, 2017 at 4:35 am
Dear All,
My teams started using the data compression option that is now available with SQL Server 2016 standard edition.
Problem is that we are not able to see this compreension as MS 2016 can only be installed in windows 8 or above and we still have windows 7.
Do you know if there is any workaround for this?
Also, if we keep the SQL Server 2012 compatibility level in our databases instead of upgrading it to SQL Server 2016, we will be able to see data compreesion?
Thank you
October 10, 2017 at 9:23 am
This doesn't quite make sense. You're using data compression, but you can't install SQL 2016? Or do you mean you want to install SQL 2016, but can't on Windows 7?
The minimum requirements are Windows 8. There's no workaround. Upgrade the OS, get a VM, install on a remote machine and access SQL there. Thsoe are the options.
You can compress tables with row/page compression when the database is in compat level 110
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply