Comments
Sort by recent activity
Does that mean you're using Clones to support application instances in Prod or that need to be backed up? Or by application aware is it a backup of the SQL Clone server itself and the databases on it? / comments
Does that mean you're using Clones to support application instances in Prod or that need to be backed up? Or by application aware is it a backup of the SQL Clone server itself and the databases on it?
@Censor1983 is there any reason why you're backing up a Clone / Clones? Clones are intended to be ephemeral copies of the Image you create and any delta changes you make can be recorded in Source Control - and they should only be on Dev/Test instances. I'm not sure I understand how Veeam plays or should play a role in this. / comments
@Censor1983 is there any reason why you're backing up a Clone / Clones? Clones are intended to be ephemeral copies of the Image you create and any delta changes you make can be recorded in Source C...
@rallen can I check what you're looking to test with this? Just to make sure I have the right context at least. My approach if I needed to keep the town, state and zip code correct in the set would be either: 1) Create your own correlated data set with a dump of "real" addresses that are publicly available from the internet and mask those values in so the addresses are all real but not YOUR real addresses 2) Use a shuffle rule to group shuffle the 3 columns together, that way all the addresses are real and they're your addresses so they're the same spread, but they no longer relate to the original row in that specific table / comments
@rallen can I check what you're looking to test with this? Just to make sure I have the right context at least.My approach if I needed to keep the town, state and zip code correct in the set would ...
@mohsin is the 2008 instance one you've connected to to catalog, or are you using it for the backend instance? Pre-requisites for the Data Catalog backend DB are 2012+ as per here: Requirements - SQL Data Catalog - Product Documentation (red-gate.com) Also is there anything in the logs: Application Logs - SQL Data Catalog - Product Documentation (red-gate.com) as it may be worth checking if there's anything obvious preventing it from displaying anything... / comments
@mohsin is the 2008 instance one you've connected to to catalog, or are you using it for the backend instance? Pre-requisites for the Data Catalog backend DB are 2012+ as per here: Requirements - S...
I don't know if this is still the case @MPughASC but previously cloned databases had an extended property set at the database level of "isClonedDatabase" set to True so if you query the extended properties you might have some luck. You should allow be able to filter and see a list in the SQL clone dashboard too though... / comments
I don't know if this is still the case @MPughASC but previously cloned databases had an extended property set at the database level of "isClonedDatabase" set to True so if you query the extended pr...
rob_w was this connection working before or is this a new connection? I'd be thinking that port 14146 is blocked if it's new. Otherwise, have you tried restarting both the SQL Clone Agent AND the SQL Clone Server service? / comments
rob_w was this connection working before or is this a new connection? I'd be thinking that port 14146 is blocked if it's new.Otherwise, have you tried restarting both the SQL Clone Agent AND the SQ...
Hey glennsharrock - just a couple of questions as this is very curious... When you run Data Masker against the instance, is Masker installed on that same server as the instance it's pointed against? Are you using the same install of DM when invoking independently and against the image? Are you running any other preparations against the Image whilst creating it? Any custom SQL Scripts or anything? If you've got logs handy for both runs (and want to just remove the top bits with server names) then I (and probably the RG folks too) would be jolly interested to see them [image] DM Logs outside Clone > The Misc. Setup Tab - Data Masker - Product Documentation (red-gate.com) "Directory for Log Files" DM Logs inside Clone > SQL Clone Dashboard > Activity > Find the Image Creation Activity > Logs KR / comments
Hey glennsharrock - just a couple of questions as this is very curious...When you run Data Masker against the instance, is Masker installed on that same server as the instance it's pointed against?...
Hey @cxc256 I don't believe you can use a Veeam backup with SQL Clone - my understanding is it needs to be a SQL Server Native .bak (full/diffs) or a Redgate SQL Backup .sqb file You can get around this by scripting the Veeam restore and then creating the image from the live DB copy and then dropping this temporary copy, which many people do anyway to test their backups so it's just 1 extra step potentially on top of an existing process. / comments
Hey @cxc256 I don't believe you can use a Veeam backup with SQL Clone - my understanding is it needs to be a SQL Server Native .bak (full/diffs) or a Redgate SQL Backup .sqb file You can get around...
Hi @vinay11 have you tried using the Text Alpha Numeric set? You should be able to set it to 6 numbers by configuring it with the option %n%n%n%n%n%n / comments
Hi @vinay11 have you tried using the Text Alpha Numeric set? You should be able to set it to 6 numbers by configuring it with the option %n%n%n%n%n%n
Hey @vinay11 we can wait and see if someone from the RG team can jump in but I thought it was as simple as updating the mappings from classification -> data set e.g. Creating masking sets from SQL Data Catalog classifications - Data Masker - Product Documentation (red-gate.com) updating the mappings for values to be masked from date to date variance? / comments
Hey @vinay11 we can wait and see if someone from the RG team can jump in but I thought it was as simple as updating the mappings from classification -> data sete.g. Creating masking sets from SQL D...