Skip to content

Invoke-DbaDbClone tries to clone all databases instead of just one #5015

@nvarscar

Description

@nvarscar

Before submitting a bug report:

  • Ensure you are able to reproduce it on the latest released version (we release often)
  • Verified this bug is not already reported in an issue
  • Verified errors are not related to permissions
  • Can reproduce in a clean PowerShell session (clean = powershell -NoProfile)
  • If issue is with Copy-DbaDatabase, using Backup-DbaDatabase | Restore-DbaDatabase still does not work

Note that we do not have the resources to make Copy-DbaDatabase work in every environment. Instead, we try to ensure Backup & Restore work in your enviornment.

Steps to Reproduce

Invoke-DbaDbClone -SqlInstance 'localhost' -Database 'AdventureWorksLT2012' -CloneDatabase 'AdventureWorksLT2012_clone'

Expected Behavior

Clone one database

Actual Behavior

PS C:\Users\scar\Desktop> Invoke-DbaDbClone -SqlInstance 'localhost' -Database 'AdventureWorksLT2012' -CloneDatabase 'AdventureWorksLT2012_clone_6.4'
WARNING: [14:56:28][Invoke-DbaDbClone] Only user databases are supported
WARNING: [14:56:28][Invoke-DbaDbClone] Only user databases are supported
WARNING: [14:56:29][Invoke-DbaDbClone] Only user databases are supported
WARNING: [14:56:29][Invoke-DbaDbClone] Only user databases are supported
WARNING: [14:56:31][Invoke-DbaDbClone] Failure | Specified clone database name 'AdventureWorksLT2012_clone_6.4' already exists.
WARNING: [14:56:31][Invoke-DbaDbClone] Failure | Specified clone database name 'AdventureWorksLT2012_clone_6.4' already exists.
WARNING: [14:56:31][Invoke-DbaDbClone] Failure | Specified clone database name 'AdventureWorksLT2012_clone_6.4' already exists.
WARNING: [14:56:31][Invoke-DbaDbClone] Failure | Specified clone database name 'AdventureWorksLT2012_clone_6.4' already exists.
WARNING: [14:56:31][Invoke-DbaDbClone] Failure | Specified clone database name 'AdventureWorksLT2012_clone_6.4' already exists.
WARNING: [14:56:31][Invoke-DbaDbClone] Failure | Specified clone database name 'AdventureWorksLT2012_clone_6.4' already exists.
WARNING: [14:56:31][Invoke-DbaDbClone] Failure | Specified clone database name 'AdventureWorksLT2012_clone_6.4' already exists.
WARNING: [14:56:32][Invoke-DbaDbClone] Failure | Specified clone database name 'AdventureWorksLT2012_clone_6.4' already exists.
WARNING: [14:56:32][Invoke-DbaDbClone] Failure | Specified clone database name 'AdventureWorksLT2012_clone_6.4' already exists.

Environmental data

  • PowerShell: 5.1
  • SQL Server: 2017

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions