You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Exception : System.Exception: Microsoft.Data.SqlClient.SqlError: The media loaded on
"\\MyBackupShare\MyServer$MyInstance\MyDatabase\LOG\MyServer$MyInstance_MyDatabase_LOG_20240405_091625.trn" is formatted to support 1 media families,
but 2 media families are expected according to the backup device specification. ---> System.Exception: Microsoft.Data.SqlClient.SqlError: The media loaded on
"\\MyBackupShare\MyServer$MyInstance\MyDatabase\LOG\MyServer$MyInstance_MyDatabase_LOG_20240405_091625.trn" is formatted to support 1 media families,
but 2 media families are expected according to the backup device specification. ---> System.Management.Automation.MethodInvocationException: Exception calling "SqlRestore"
with "1" argument(s): "Restore failed for Server 'MyServer\MyInstance'. " ---> Microsoft.SqlServer.Management.Smo.FailedOperationException: Restore failed for Server
'MyServer\MyInstance'. ---> Microsoft.SqlServer.Management.Smo.SmoException: Microsoft.Data.SqlClient.SqlError: The media loaded on
"\\MyBackupShare\MyServer$MyInstance\MyDatabase\LOG\MyServer$MyInstance_MyDatabase_LOG_20240405_091625.trn" is formatted to support 1 media families,
but 2 media families are expected according to the backup device specification.
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean
errorsAsMessages, Boolean retry)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
at CallSite.Target(Closure , CallSite , Object , Object )
--- End of inner exception stack trace ---
at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
TargetObject : MyServer\MyInstance
CategoryInfo : NotSpecified: (MyServer\MyInstance:String) [], Exception
FullyQualifiedErrorId : dbatools_Restore-DbaDatabase
ErrorDetails :
InvocationInfo : System.Management.Automation.InvocationInfo
ScriptStackTrace : at Stop-Function, <No file>: line 97891
at Restore-DbaDatabase<End>, <No file>: line 71290
at Test-DbaLastBackup<Process>, <No file>: line 85210
at <ScriptBlock>, <No file>: line 5
PipelineIterationInfo : {}
Steps to Reproduce
To prepare the test, create a new database, then create full, diff and log backups of the database, including at least one mirrored copy of each backup, using the MIRROR TO clause of the BACKUP command. T-SQL for these steps not included here. The command below is just the dbatools command to run Test-DbaLastBackup after you've created a database and backups which include at least one mirrored copy.
Please confirm that you are running the most recent version of dbatools
2.1.12
Other details or mentions
I created dbatools bug report #5360 on April 11, 2019. A fix was created via #5361 which seems to work for backup types of FULL and DIFF, but if you include LOG backups in your test restore, you still get the errors.
What PowerShell host was used when producing this error
Microsoft SQL Server 2022 (RTM-CU12) (KB5033663) - 16.0.4115.5 (X64) Mar 4 2024 08:56:10 Copyright (C) 2022 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor)
.NET Framework Version
.NET Framework 4.7.4051.0
The text was updated successfully, but these errors were encountered:
Verified issue does not already exist?
I have searched and found no existing issue
What error did you receive?
Steps to Reproduce
To prepare the test, create a new database, then create full, diff and log backups of the database, including at least one mirrored copy of each backup, using the MIRROR TO clause of the BACKUP command. T-SQL for these steps not included here. The command below is just the dbatools command to run Test-DbaLastBackup after you've created a database and backups which include at least one mirrored copy.
Please confirm that you are running the most recent version of dbatools
2.1.12
Other details or mentions
I created dbatools bug report #5360 on April 11, 2019. A fix was created via #5361 which seems to work for backup types of FULL and DIFF, but if you include LOG backups in your test restore, you still get the errors.
What PowerShell host was used when producing this error
Windows PowerShell ISE (powershell_ise.exe)
PowerShell Host Version
SQL Server Edition and Build number
.NET Framework Version
The text was updated successfully, but these errors were encountered: