Subscribe

Deleting a SMSQL clone on a remote server using PowerShell

Hi,

A customer is using SMSQL to create clones on remote servers and is wondering if it should be possible to delete the clones from a central server using the PowerShell (i.e. - the clone is mounted on a different server).  He gets an error when he tries to do this (not sure of the exact message).  It appears from the documentation that this is possible but I wanted to check to be sure.

Thanks.

Re: Deleting a SMSQL clone on a remote server using PowerShell

I would not expect the ability to remove the clone from the remote system unless you were able to rsh into the remote system unless you are using Windows Server 2008R2. With Windows Server 2008R2 you can do remote shell commands with powershell but not all commandlets will work, so you would first have to be running Windows Server 2008R2 and have the remote shell enabled.

John Parker

Re: Deleting a SMSQL clone on a remote server using PowerShell

Thanks John. I appreciate the information.

---

Trey Prinz

Systems Engineer

NetApp

512.287.7204 Direct

512.633.4851 Mobile

prinz@netapp.com

www.netapp.com

Re: Deleting a SMSQL clone on a remote server using PowerShell

Hi,

It is possible to remove clones created on a remote SQL Server host using SMSQL 5.0. You'll have to use the SMSQL 5.0 powershell command-let. In this case the commadlet in question is delete-clone. The syntax is as follows: -

delete-clone [-Server <ServerName>] [-Database <<SQL server instance>,<Number of databases>,<db1>,<db2>,db3>..>

[-Username <username>] [-Password <pwd>] [-ServerInstance <SQL

Server Instance>] [<CommonParameters>]

If you facing any errors here, please post the SMSQL logs to this thread.

Regards,

Sourav.

Re: Deleting a SMSQL clone on a remote server using PowerShell

Thanks Sourav. So, does that mean that you don't need to have the rsh capability that is built into Windows 2008.

Let me check with the customer on the SMSQL version and if he can provide the logs.

Take care.

---

Trey Prinz

Systems Engineer

NetApp

512.287.7204 Direct

512.633.4851 Mobile

prinz@netapp.com

www.netapp.com

Re: Deleting a SMSQL clone on a remote server using PowerShell

Hi Sourav,

The customer is running 5.0.0.38. He says that there is nothing logged to the PowerShell window other than an error message. Looking in the SMSQL GUI, I see logs for Backup, Config, and Restore but not for Clone.

Is there another place he should be looking for the logs.

Thanks.

---

Trey Prinz

Systems Engineer

NetApp

512.287.7204 Direct

512.633.4851 Mobile

prinz@netapp.com

www.netapp.com

Re: Deleting a SMSQL clone on a remote server using PowerShell

That's correct. You won't need the RSH capability. What you will need though is an SMSQL installation on both the remote server as well as then one from which you are centrally managing the clone lifecycles.

Regards,

Sourav.

Re: Deleting a SMSQL clone on a remote server using PowerShell

Hi Prinz,

The RESTORE logs in SMSQL are what I need. They contain the messages from cloning operation as well. Just send me one log from the time that the error happened.

Regards,

Sourav.

Re: Deleting a SMSQL clone on a remote server using PowerShell

Thanks Sourav. It sounds like he might need to call support on this one because he told me SMSQL is already installed on the remote server. In fact, wouldn't it need to be installed on the remote server if you wanted to create a clone there or do you just need SnapDrive for that.

Take care.

---

Trey Prinz

Systems Engineer

NetApp

512.287.7204 Direct

512.633.4851 Mobile

prinz@netapp.com

www.netapp.com

Re: Deleting a SMSQL clone on a remote server using PowerShell

SMSQL will have to be installed at the remote server as well where the clone was created. Let me know if support advices otherwise.

Regards,

Sourav.