Subscribe

SMSQL Delete-Clone Failure - Database Name specified DBTest is not valid for delete clone operation

[ Edited ]

Im using SMSQL 7.2

 

Cloning the database went fine, however when trying to delete the clone i get the below log

 

Initializing [delete-clone]
Connecting to server: [SQLSRV01] [processing]
Connecting to server: [SQLSRV01] [completed]
Retrieving SnapManager Configuration Information: [processing]
Retrieving SnapManager Configuration Information: [completed]
Database Name specified DBTest is not valid for delete clone operation as there are dependent clones.
An Error occured while deleting the Database clone. Please check the SnapManager Reports/Windows EventLogs for more information.
Details:The pipeline has been stopped.

 

delete-clone : Database Name specified DBTest is not valid for delete
clone operation as there are dependent clones.
At line:1 char:1
+ delete-clone -Server SQLSRV01 -Database 'DBTest'> c:\temp\log.txt
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (SMSQLPSSnapIn.SMSQLPSDeleteClo
ne:SMSQLPSDeleteClone) [delete-clone], Exception
+ FullyQualifiedErrorId : [Dependent Clone Exists],SMSQLPSSnapIn.SMSQLPSDeleteClone

 

When trying to use the clone wizard GUI to remove the clone, i cannot select the database to delete.

 

This happens when cloning active databases and also cloning from an existing backup set

 

 

Im hoping to use this process to Mount some snapshots for our Datawarehouse ETL to use on a nightly basis.

 

Thanks.

Re: SMSQL Delete-Clone Failure - Database Name specified DBTest is not valid for delete clone operat

Hello,

not sure what exactly you are doing, but if you have a clone of a clone, you cannot remove the parent clone, without removing the child clone first.

does that help?

 

Domenico

Re: SMSQL Delete-Clone Failure - Database Name specified DBTest is not valid for delete clone operat

[ Edited ]

Thanks for the reply, 

 

Thats what netapp support said, however this as far as i am aware isnt a clone of a clone.

 

My Steps for this are simple.

 

in the SMSQL GUI i use the clone wizard to clone active production databases.

 

I follow the steps and specify what i would like the clones to be called and which server i would like the clones to be mounted to, this step works fine.

 

It creates the snapshot of the volumes required, it mounts those volumes on the destination sql server and then brings the databases online at the destination.

 

However the only way then to get rid of the cloned databases, are to manually dismount the databases in sql management studio and then disconnect the luns in snapdrive.

 

I could understand if i had cloned a clone but that isnt the case.

 

 

PS my end goal here is to automate the refresh of our test and development database servers.

Re: SMSQL Delete-Clone Failure - Database Name specified DBTest is not valid for delete clone operat

Are you detaching the database that is using the clone files?

Re: SMSQL Delete-Clone Failure - Database Name specified DBTest is not valid for delete clone operat

Has anyone else with this issue determined how to discover where these dependies reside and how to remove them?

 

Thanks!

Re: SMSQL Delete-Clone Failure - Database Name specified DBTest is not valid for delete clone operat

Same issue here on SMSQL 7.2.  I have no dependent clones.  Delete-clone fails in GUI and in CLI.  Anyone know if this is resolved in 7.2.1?

 

Thanks,

Joe Wetmore