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)