Question about SQL Server 2014 and NVMe drive issues.
Question about SQL Server 2014 and NVMe drive issues.
Looking ahead, upgrading to an NVMe drive will be impossible since Act! is essential for my operations unless someone on this forum provides a workaround. Any suggestions would be greatly appreciated.
I own an older business application named Act!. The version I use is no longer supported. During installation, it demands SQL Server 2014, which comes bundled in the installer. Recently, I moved from a SATA SSD to an NVMe SSD. I encountered errors during setup and found the newer drives incompatible with them. Although the main problem is that SQL Server struggles with standard native sector sizes over 512 bytes and 4 KB, I verified via the command prompt that this new drive doesn’t exceed that limit. Despite this, the software still failed to install properly. Eventually, I discarded the NVMe drive and swapped it for a slower SATA SSD (Samsung 2 Tb 870 EVO), allowing the installation to finish without issues.
Looking ahead, upgrading to an NVMe drive will be impossible since Act! is essential for my operations unless someone on this forum provides a workaround. Any suggestions would be greatly appreciated.
TransHailey
02-09-2016, 12:57 PM #3The actual solution lies in discarding the outdated and very old software. There are numerous options available that can transform the database into a more contemporary format.
CaptainFrix
02-19-2016, 01:46 AM #4It's an MS SQL issue, not Act! The goal is to check if you can set up or store a SQL database on a drive with a 4K sector partition or volume. Alternatively, you may need to format an NVMe drive with a 4K sector size. Refer to the provided links for more details.
. While I can install Act on another drive, selecting the SQL path isn't an option.
I verified that the drive indeed has a 4K sector size, but the issues remain. Additionally, installing SQL is not possible on drives other than the primary Windows drive (C. While I can install Act on another drive, selecting the SQL path isn't an option.
KenjiTheGreat
02-22-2016, 01:35 PM #6If you already have SQL Server installed, use it instead of Act.
JotbotPlayz
03-10-2016, 12:03 PM #8It might be that the command gives varying outcomes for the WD Blue 1 TB and WD Black 2 TB drives. You can't confirm this because you've already submitted the drive. I divided my 2TB drive into C: and T: and both show a sector size of 4096.