AdventureWorks2016CTP3

---

In Microsoft SQL Server 2016 - Querying Data with Transact-SQL, Don Pezet tells us "we're going to be using the AdventureWorks2016CTP3 database throughout this show ... available for download from Microsoft website." However, restoring that database to Microsoft SQL Server 2016 fails.

SQL Server 2016 (13.0.5026.0) Evaluation can't restore AdventureWorks2016CTP3

Restore Database
Device
File
C:\temp\AdventureWorks2016CTP3.bak (https://www.microsoft.com/en-us/download/details.aspx?id=49502)
Backup media verified successfully

TITLE: Microsoft SQL Server Management Studio

Restore of database 'AdventureWorks2016CTP3' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

ADDITIONAL INFORMATION:

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

An error occurred during recovery, preventing the database 'AdventureWorks2016CTP3' (5:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support. (Microsoft SQL Server, Error: 3414)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&EvtSrc=MSSQLServer&EvtID=3414&LinkId=20476

BUTTONS:

OK

Details:

===================================

Restore of database 'AdventureWorks2016CTP3' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

Program Location:

at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.PerformTask(ITaskExecutionContext context)
at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.Perform(ITaskExecutionContext context)
at Microsoft.SqlServer.Management.TaskForms.TaskExecutionManager.ExecuteTaskSequence(ISfcScriptCollector collector)

===================================

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

Program Location:

at Microsoft.SqlServer.Management.Smo.RestorePlan.Execute()
at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.PerformTask(ITaskExecutionContext context)

===================================

An error occurred during recovery, preventing the database 'AdventureWorks2016CTP3' (5:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support. (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&EvtSrc=MSSQLServer&EvtID=3414&LinkId=20476

Server Name: DESKTOP-KGNGKD4
Error Number: 3414
Severity: 21
State: 1
Line Number: 1

Program Location:

at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)

@Alan-Feldstein it was great to see you in the "Office Hours" segment we did here is a response from Don:

"The CTP3 in the name means we filmed it using Community Technology Preview 3, which likely explains why the restore isn't working. You can download the latest version of the database from Microsoft's GitHub page. All of the new links can be found here: https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15"

Yes, I did eventually find that Microsoft URL. On that page, AdventureWorks2016.bak can be found. SQL Server 2016 (13.0.5026.0) Evaluation can indeed restore that.

I can't give you a firsthand report on that which is available on the GitHub page, but Don is probably right about that too.