Activity overview
Latest activity by giumaRE
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...
Call powershell from SQL Agent Job to refresh a clone
Hi,For my convenience I manage the update of clones via powershell scripts launched using sql job agent.The problem is that the job does not raise the error in case there are problems when generati...
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
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
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?
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
Create Clone failed
Hi,I'm receiving the error when I create the clone, but the clone not exist in the target SQL Server instance:022-05-12 16:44:23.604 +02:00 [ERR] CreateCloneRequestEvent (clone name: "Rete") Operat...