how to downgrade sql server 2019 standard to sql server 2014 standard

I have backup sql server database 2014 and restored on 2019 for a production environment. Meanwhile our core appkication which runs on tomcat 8 have extrem slow speeds, hence need to restore database...

peterkimani

Copper Contributor

Jul 05, 2022

bake13

i was trying to set high affinity for processor but i got below

TITLE: Microsoft SQL Server Management Studio
------------------------------

Alter failed. (Microsoft.SqlServer.Smo)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.47008.0&Evtsrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+AffinityInfo&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The affinity mask specified is greater than the number of CPUs supported or licensed on this edition of SQL Server. (Microsoft SQL Server, Error: 5833)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-5833-database-engine-error

BUTTONS: