Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using ReuseFolderStructure causes errors while migrating Database #13

Closed
dhrubomoy opened this issue Mar 7, 2016 · 2 comments
Closed

Comments

@dhrubomoy
Copy link
Contributor

Specifications

Source: Windows Server 2003
SQL Server Version: 2005

Destination: Windows Server 2008r2
SQL Server Version: 2008

Command: Copy-SqlDatabase -Source SourceName -Destination DestinationName -Verbose -BackupRestore -ReuseFolderstructure -NetworkShare \\fileshare\sql\migration -All -Force

Expected behavior

Database migration should complete

Actual Behavior

Shows whole bunch of errors. Like:

(1) Join-AdminUnc : Cannot process argument transformation on parameter 'filepath'. Cannot convert value to type System.String.
At C:\dbatools\Function\Copy-SqlDatabase.ps1:650 char:45...

(2) WARNING: Restore failed: Restore failed for Server 'Destination'.

(3) Copy-SqlDatabase : Failed to update DatabaseOwnershipChaining for False on something on Destination
At C:\dbatools\Functions\Copy-SqlDatabase.ps1:1039 char:3...

(4) Copy-SqlDatabase : Failed to update Trustworthy to False for something on Destination
At C:\dbatools\Functions\Copy-SqlDatabase.ps1:1039 char:3...

Workaround

Not using -ReuseFolderstructure seems to migrate database properly.

@potatoqualitee
Copy link
Member

Cannot repro even with same versions of sql (2005->2008). This may have been fixed inadvertently.

@potatoqualitee
Copy link
Member

Please let us know if this has been fixed for sure in 0.9.127

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants