microsoft / microsoft/sql-server-samples

Error restoring AdventureWorks2016_EXT.bak and AdventureWorksDW2016_EXT.bak

Open
#422 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
PowerShell
Stars
11.2k
Forks
9.1k
Avg merge
2d 7h
Merged PRs (30d)
14

Description

Best regards,
I downloaded the AdventureWorks2016_EXT.bak and AdventureWorksDW2016_EXT.bak files. However, when trying to restore the backups, they are blocked by 35% and generate the following error message, and then appear in the object explorer in Suspect state:

=====================================================================
Restore of database 'AdventureWorks2016_EXT' 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 'AdventureWorks2016_EXT' (11: 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%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=3414&LinkId=20476

Server Name: C-JRAMIRJA3
Error Number: 3414
Severity: 21
State: 4
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)

The files that are not extended, AdventureWorks2016.bak and AdventureWorksDW2016.bak, are restored without problems.

Could you please help me by focusing on the solution?

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the restore of AdventureWorks2016_EXT.bak and AdventureWorksDW2016_EXT.bak in SQL Server and inspect the recovery errors associated with error 3414. Compare the extended backups with AdventureWorks2016.bak and AdventureWorksDW2016.bak, which restore successfully; done means identifying the cause and documenting a confirmed restoration fix or backup issue.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.