Comments
Sort by recent activity
Thanks for the response. But something in the users settings got out of wake. He did a reset default settings and everything started working as he expected. / comments
Thanks for the response. But something in the users settings got out of wake. He did a reset default settings and everything started working as he expected.
Sweet, thanks for that info. / comments
Sweet, thanks for that info.
I guess I could find and replace to remove the INSERT INTO and VALUES to nothing.
I actually just need the actual data in the () for what I am trying to accomplish.
So I ended up breaking it up. Do 1000, then sort desc and grab the extra 346 values. / comments
I guess I could find and replace to remove the INSERT INTO and VALUES to nothing.
I actually just need the actual data in the () for what I am trying to accomplish.
So I ended up breaking it up. D...
$redgateCloneURL = 'http://devclndbs01.exclaim-dev.com:14145'
Connect-SqlClone -ServerUrl $redgateCloneURL
$imagelist = Get-SqlCloneImage
$clonelist = Get-SqlClone
foreach ($name in $imagelist) {
$clonelist | Where-Object ParentImageId -EQ $name.Id | Select-Object @{Name="Image Name";Expression={$name.name}}, Name, State
}
$clonelist = Get-SqlClone
I put this code together. Do you know how I can return the located on server that the clone is hosted on? I could not figure out how to capture this server name. / comments
$redgateCloneURL = 'http://devclndbs01.exclaim-dev.com:14145'
Connect-SqlClone -ServerUrl $redgateCloneURL
$imagelist = Get-SqlCloneImage
$clonelist = Get-SqlClone
foreach ($name in $imagelist) ...
We patch the OS monthly. So Windows patches are applied the servers are rebooted. I had a lot of issues in the beginning of SQL Clones release that the order in which things came up caused issues with clones hosted on other servers. This has not been an issue with the latest versions. I patch SQL Clone manually since we have issues with certificate authorizations. Wish there was something you could do about that. / comments
We patch the OS monthly. So Windows patches are applied the servers are rebooted. I had a lot of issues in the beginning of SQL Clones release that the order in which things came up caused issues...
I can run more tests, but without me starting a stop watch and watching is there any log that could be enabled that would capture the image creation? / comments
I can run more tests, but without me starting a stop watch and watching is there any log that could be enabled that would capture the image creation?
I have it running now and will compare the times to these last two runs and then a time before now that I can mine this data. / comments
I have it running now and will compare the times to these last two runs and then a time before now that I can mine this data.
What we have done is take our production database create a cloned image and masked all PII data. We then take a backup of that and create another image that we then deploy to our Dev and QA environments. We have 4 dev and 4 QA environments and each get there own clone of the masked database image. It is just in QA where they are doing more elaborate testing where they need the data to mature for proper financial testing. / comments
What we have done is take our production database create a cloned image and masked all PII data. We then take a backup of that and create another image that we then deploy to our Dev and QA enviro...
The use case for us is going to be this data will be in QA for an extended period of time. Accounts will be aging and QA will be doing testing. If the data is lost all that would be lost as well.
I guess without being able to recover in Clone from a failure a that point would not work since that functionality is not there. And I guess I could recover from a SQL FULL and Diff. I just was not planning on that storage requirement as we move these processes down to lower level environments.
Just trying to look at all the risks and gotchas as we move this data around with SQL Clone. / comments
The use case for us is going to be this data will be in QA for an extended period of time. Accounts will be aging and QA will be doing testing. If the data is lost all that would be lost as well....
I know how to maneuver in windows and the RDP tool does allow for resize.
My comment was a software application these days should be able to handle screen resolution sizing. / comments
I know how to maneuver in windows and the RDP tool does allow for resize.
My comment was a software application these days should be able to handle screen resolution sizing.