Comments
Sort by recent activity
I followed the instructions of the link you sent me and I changed the code in this way $clones = Get-SqlClone | Where-Object { $_.Name -eq $DatabaseName -and $_.LocationId -eq $SqlServerInstance.Id } Thank you, Eddie / comments
I followed the instructions of the link you sent me and I changed the code in this way$clones = Get-SqlClone | Where-Object { $_.Name -eq $DatabaseName -and $_.LocationId -eq $SqlServerInstance.Id ...
Hi Eddie, yes, exactly..it is what I would expect too, instead I receive an error. I Don't understand why in the first case if I don't find a clone resource the cmdlet returns null, instead in the second case if I don't find a clone resource the cmdlet returns an error. / comments
Hi Eddie,yes, exactly..it is what I would expect too, instead I receive an error.I Don't understand why in the first case if I don't find a clone resource the cmdlet returns null, instead in the se...
This is the problem that I found out while I was executing the script below. Get-SQLClone function has different behaviour in OPTION 1 and OPTION 2 OPTION 2 raise an exception, OPTION 1 no Connect-SqlClone -ServerUrl $ServerUrl #list available image related to $ImageName parameter $images = Get-SqlCloneImage -Name $ImageName
#get the last image available $image = $images | Sort-Object -Property CreatedDate -Descending | Select-Object -First 1 # get the sql clone sql server instance $sqlServerInstance = Get-SqlCloneSqlServerInstance -MachineName $MachineName
########################## OPTION 1 ################ $clones = Get-SqlClone -Image $image if (!($null -eq $clones)) { "Will not remove image {0} because it has {1} dependent clone(s)." -f $image.Name, $clones.Count } else { "Will not remove image {0} because this is a test." -f $image.Name } ##################################################
#####################OPTION 2 ######################### try{ $clones = Get-SqlClone -Name $DatabaseName -Location $SqlServerInstance }
catch { "ERROR::<< {0} >>" -f $error.Exception.Message # Write-Host $_ Write-Output $error.Exception.Message # exit -1; } ##################################################
/ comments
This is the problem that I found out while I was executing the script below.Get-SQLClone function has different behaviour in OPTION 1 and OPTION 2OPTION 2 raise an exception, OPTION 1 noConnect-Sql...
I'll open a ticket to Redgate and I'll keep you posted Many thanks for your help / comments
I'll open a ticket to Redgate and I'll keep you postedMany thanks for your help
Is it possible there are some dirty data left in the SQLClone_Config database? / comments
Is it possible there are some dirty data left in the SQLClone_Config database?
Please find attached the log file and a csv with the contents of the table Clones filtered for "Rete" DB / comments
Please find attached the log file and a csv with the contents of the table Clones filtered for "Rete" DB
nothing, no file / comments
nothing, no file
Hi, No, nothing like that. There are only five clones: MarketingScrignoV2 Creditcheck DWH ChargeBack I also checked querying sys.sysdatabases / comments
Hi,No, nothing like that.There are only five clones: MarketingScrignoV2CreditcheckDWHChargeBack I also checked querying sys.sysdatabases
Thank you very much! / comments
Thank you very much!