SQL Server Error: Database 'Northwind' cannot be upgraded because its non-release version (539)

Last Reply one year ago By dharmendr

Posted one year ago

As my last questions answered, I have the database in 2017 format that is NorthWind database. While Restoring database i got the error

TITLE: Microsoft SQL Server Management Studio
Attach database failed for Server 'DESKTOP-4TMF7S6'.  (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=14.0.17230.0+((SSMS_Rel_17_4).180313-0650)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Database 'Northwind' cannot be upgraded because its non-release version (539) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database.
Could not open new database 'Northwind'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 950)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=950&LinkId=20476