Data Backup and Recovery

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

ktsupport
5,830 Views

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.

6 REPLIES 6

dmauro
5,678 Views

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

ktsupport
5,669 Views

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.

BillKenworthy
5,236 Views

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

bfarthing
4,923 Views

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

 

Thanks!

joew
4,796 Views

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

seanwik
3,712 Views

You also get this errormessage when the database is not an clone, I just had an example when a previosly cloned database by some reason had become a physical database with files on the ordinary LUNS.  I do not yet know why this happens, but each time it has happened the database file names contain the phrase "Primary"  if I remember correctly. 

Public