Copy-DbaDatabase more errors after #10389

[virtualdreams]

Verified issue does not already exist?

I have searched and found no existing issue

What error did you receive?

Now that the errors from the Copy-Database ( see #10389 ) command should actually be fixed, new errors are popping up that are even stranger. I think your AI messed something up.

Steps to Reproduce

I tried to copy three databases (CopyTest, CopyTest2 and CopyTest3), which resulted in the output shown below. Databases that were not selected at all are being affected here, especially on the destination server.

$source_instance = "server12"
$target_instance = "server11"
$SharedPath = "\\server.example.com\mssqlbackup\Migrations"

Get-DbaDatabase -SqlInstance $source_instance |
	Out-GridView -Title "Select databases to copy" |
	Copy-DbaDatabase -Source $source_instance -Destination $target_instance -BackupRestore -SharedPath $SharedPath -WithReplace -NumberFiles 1

In the GridView, only the three databases CopyTest, CopyTest2, and CopyTest3 are selected.

WARNING: [10:57:00][Set-DbaDbOwner] AdventureWorksDW2022 on server11\TEST is not in an updateable state and can not be altered. It will be skipped.
WARNING: [10:57:00][Set-DbaDbOwner] AdventureWorks2022 on server11\TEST is not in an updateable state and can not be altered. It will be skipped.
WARNING: [10:57:00][Set-DbaDbOwner] TEST_CONTAINED_msdb on server11\TEST is not in an updateable state and can not be altered. It will be skipped.
WARNING: [10:57:00][Set-DbaDbOwner] Database1 on server11\TEST is not in an updateable state and can not be altered. It will be skipped.
WARNING: [10:57:00][Set-DbaDbOwner] Database [Database2] is not accessible. Skipping.
WARNING: [10:57:00][Set-DbaDbOwner] Database3 on server11\TEST is not in an updateable state and can not be altered. It will be skipped.
WARNING: [10:57:00][Set-DbaDbOwner] Database [Database4] is not accessible. Skipping.
WARNING: [10:57:00][Set-DbaDbOwner] Database5 on server11\TEST is not in an updateable state and can not be altered. It will be skipped.
WARNING: [10:57:00][Set-DbaDbOwner] Database6 on server11\TEST is not in an updateable state and can not be altered. It will be skipped.
WARNING: [10:57:01][Set-DbaDbOwner] TEST_CONTAINED_master on server11\TEST is not in an updateable state and can not be altered. It will be skipped.
WARNING: [10:57:01][Copy-DbaDatabase] Failed to update DatabaseOwnershipChaining for False on  on server11\TEST.
WARNING: [10:57:01][Copy-DbaDatabase] Failed to update Trustworthy to False for  on server11\TEST.
WARNING: [10:57:01][Copy-DbaDatabase] Failed to update BrokerEnabled to False for  on server11\TEST.

WARNING: [10:57:03][Copy-DbaDatabase] Failure attempting to restore CopyTest2 to server11\TEST | Microsoft.Data.SqlClient.SqlError: Das Sicherungsmedium "\\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041057.bak" kann nicht geöffnet werden. Betriebssystemfehler 2(Das System kann die angegebene Datei nicht finden.).
Type     Name      Status     Notes
----     ----      ------     -----
Database CopyTest  Successful Failed to apply the following properties: Ownership chaining, Trustworthy, Message broker, Read only
Database CopyTest2 Failed     Microsoft.Data.SqlClient.SqlError: Das Sicherungsmedium "\\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041057.…

Please confirm that you are running the most recent version of dbatools

2.8.3

Other details or mentions

No response

What PowerShell host was used when producing this error

PowerShell Core (pwsh.exe)

PowerShell Host Version

Name Value

---

PSVersion 7.6.3
PSEdition Core
GitCommitId 7.6.3
OS Microsoft Windows 10.0.20348
Platform Win32NT
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0…}
PSRemotingProtocolVersion 2.4
SerializationVersion 1.1.0.1
WSManStackVersion 3.0

SQL Server Edition and Build number

Microsoft SQL Server 2022 (RTM-CU24-GDR) (KB5083252) - 16.0.4250.1 (X64) Mar 13 2026 00:15:17 Copyright (C) 2022 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2022 Standard 10.0 (Build 20348: )

.NET Framework Version

PSChildName Version

---

Client 4.8.04161
Full 4.8.04161
Client 4.0.0.0

[virtualdreams]

Each execution produces a different result.

Copy-DbaDatabase -Source server12\TEST -Destination server11\TEST -Database CopyTest,CopyTest2,CopyTest3 -SharedPath \\server.example.com\mssqlbackup\Migrations -WithReplace -BackupRestore

WARNING: [10:39:00][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041038-1-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:00][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041038-2-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:00][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041038-3-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:00][Copy-DbaDatabase] Failure attempting to restore CopyTest2 to server11\TEST
WARNING: [10:39:00][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest3_202608041039-1-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:00][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest3_202608041039-2-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:00][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest3_202608041039-3-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:00][Copy-DbaDatabase] Failure attempting to restore CopyTest3 to server11\TEST
Type     Name      Status     Notes
----     ----      ------     -----
Database CopyTest  Successful
Database CopyTest2 Failed     Failed to restore database
Database CopyTest3 Failed     Failed to restore database

PS C:\Users\my.username> Copy-DbaDatabase -Source server12\TEST -Destination server11\TEST -Database CopyTest,CopyTest2,CopyTest3 -SharedPath \\server.example.com\mssqlbackup\Migrations -WithReplace -BackupRestore

WARNING: [10:39:24][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041039-1-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:24][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041039-2-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:24][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041039-3-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:24][Copy-DbaDatabase] Failure attempting to restore CopyTest2 to server11\TEST
Type     Name      Status     Notes
----     ----      ------     -----
Database CopyTest  Successful
Database CopyTest2 Failed     Failed to restore database
Database CopyTest3 Successful

PS C:\Users\my.username> Copy-DbaDatabase -Source server12\TEST -Destination server11\TEST -Database CopyTest,CopyTest2,CopyTest3 -SharedPath \\server.example.com\mssqlbackup\Migrations -WithReplace -BackupRestore

WARNING: [10:39:40][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest3_202608041039-1-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:40][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest3_202608041039-2-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:40][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest3_202608041039-3-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:40][Copy-DbaDatabase] Failure attempting to restore CopyTest3 to server11\TEST
Type     Name      Status     Notes
----     ----      ------     -----
Database CopyTest  Successful
Database CopyTest2 Successful
Database CopyTest3 Failed     Failed to restore database

PS C:\Users\my.username> Copy-DbaDatabase -Source server12\TEST -Destination server11\TEST -Database CopyTest,CopyTest2,CopyTest3 -SharedPath \\server.example.com\mssqlbackup\Migrations -WithReplace -BackupRestore

WARNING: [10:39:52][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041039-1-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:52][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041039-2-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:52][Test-DbaBackupInformation] Backup File \\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041039-3-of-3.bak cannot be read by server11\TEST. Does the service account (DOMAIN\DBServer-TEST) have permission?
WARNING: [10:39:52][Copy-DbaDatabase] Failure attempting to restore CopyTest2 to server11\TEST
Type     Name      Status     Notes
----     ----      ------     -----
Database CopyTest  Successful
Database CopyTest2 Failed     Failed to restore database
Database CopyTest3 Successful

[virtualdreams]

By limiting the number of files to 1.

PS C:\Users\my.username> Copy-DbaDatabase -Source server12\TEST -Destination server11\TEST -Database CopyTest,CopyTest2,CopyTest3 -SharedPath \\server.example.com\mssqlbackup\Migrations -WithReplace -BackupRestore -NumberFiles 1

WARNING: [10:45:05][Copy-DbaDatabase] Failure attempting to restore CopyTest2 to server11\TEST | Microsoft.Data.SqlClient.SqlError: Das Sicherungsmedium "\\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041045.bak" kann nicht geöffnet werden. Betriebssystemfehler 2(Das System kann die angegebene Datei nicht finden.).
WARNING: [10:45:06][Copy-DbaDatabase] Failure attempting to restore CopyTest3 to server11\TEST | Microsoft.Data.SqlClient.SqlError: Das Sicherungsmedium "\\server.example.com\mssqlbackup\Migrations\CopyTest3_202608041045.bak" kann nicht geöffnet werden. Betriebssystemfehler 2(Das System kann die angegebene Datei nicht finden.).
Type     Name      Status     Notes
----     ----      ------     -----
Database CopyTest  Successful
Database CopyTest2 Failed     Microsoft.Data.SqlClient.SqlError: Das Sicherungsmedium "\\server.example.com\mssqlbackup\Migrations\CopyTest2_202608041045.bak" kann nicht geöffnet we…
Database CopyTest3 Failed     Microsoft.Data.SqlClient.SqlError: Das Sicherungsmedium "\\server.example.com\mssqlbackup\Migrations\CopyTest3_202608041045.bak" kann nicht geöffnet we…

[potatoqualitee]

@virtualdreams I appreciate the bug report but dbatools had bugs when humans were coding too. Your issue could have done without the diss.

[virtualdreams]

@potatoqualitee I'm sorry, but that wasn't meant to be a dissing comment.

[potatoqualitee]

@virtualdreams thank you, can you please try the fix/10512-copydbadatabase branch? Remember to use -Force when importing. if you are unsure how to do branching, you can download https://github.com/dataplat/dbatools/archive/refs/heads/fix/10512-copydbadatabase.zip

[virtualdreams]

Am I doing something wrong? I extracted the ZIP folder from the link and tried to import it. dbatools isn't installed on the system I'm testing on.

Import-Module .\dbatools-fix-10512-copydbadatabase\ -Force
Import-Module: The specified module '.\dbatools-fix-10512-copydbadatabase\' was not loaded because no valid module file was found in any module directory.

[potatoqualitee]

should work if you remove that trailing "\" or be explicit all the way down to dbatools.psd1

Import-Module '.\dbatools-fix-10512-copydbadatabase\dbatools.psd1' -Force

[virtualdreams]

Thanks, that tip helped. The module is now loading. I'll get back to you tomorrow with the results.