Comments
Sort by recent activity
Good Morning, Thanks for your inquiry with SQL Clone. We wanted to focus on the Powershell Commandlets being available locally with the SQL Clone tool: https://documentation.red-gate.com/clone/automation Please let me know if you have any other questions or concerns. Thanks! / comments
Good Morning,Thanks for your inquiry with SQL Clone.We wanted to focus on the Powershell Commandlets being available locally with the SQL Clone tool:https://documentation.red-gate.com/clone/automat...
Good Afternoon, Thanks for your inquiry with Redgate Monitor. Unfortunately, there isn't a way to customize the overviews page beyond what we detail in the documentation: https://documentation.red-gate.com/monitor/availability-group-overview-239668432.html Please let us know if you have any other questions or concerns. Thanks! / comments
Good Afternoon,Thanks for your inquiry with Redgate Monitor.Unfortunately, there isn't a way to customize the overviews page beyond what we detail in the documentation: https://documentation.red-ga...
Good Afternoon, Thanks for your inquiry with SQL Backup. While you can in theory schedule jobs in such a manner if you know their estimated time of completion, there isn't an explicit setting that hardcodes this to happen. Please let me know if you have any other questions or concerns. Thanks! / comments
Good Afternoon,Thanks for your inquiry with SQL Backup.While you can in theory schedule jobs in such a manner if you know their estimated time of completion, there isn't an explicit setting that ha...
Good Afternoon, Can you try restarting the SQL Monitor Base Monitor Windows Service? That should allow you to reset the process with minimal impact. Thanks! / comments
Good Afternoon,Can you try restarting the SQL Monitor Base Monitor Windows Service? That should allow you to reset the process with minimal impact.Thanks!
Good Morning! Thanks for your inquiry with Redgate SQL Backup. Can you describe the steps involved with authenticating oneself with the Flashblade storage device? This can help with determining how compatible this is with Redgate SQL Backup. Thanks! / comments
Good Morning!Thanks for your inquiry with Redgate SQL Backup.Can you describe the steps involved with authenticating oneself with the Flashblade storage device?This can help with determining how co...
Good Afternoon, Thanks for your inquiry with SQL Clone. We would recommend the following method:
Move the filetable to a different database within the same instance.
Run the below query
ALTER DATABASE SilverSuite SET FILESTREAM ( NON_TRANSACTED_ACCESS = OFF , DIRECTORY_NAME = NULL If you get an error message, try setting the NON_TRANSACTED_ACCESS to FULL in the user interface (DB properties/options) and then execute the ALTER DATABASE command again. Once this is done, please check if the image can be created. Thanks! / comments
Good Afternoon,Thanks for your inquiry with SQL Clone.We would recommend the following method:
Move the filetable to a different database within the same instance.
Run the below query
ALTER DATABA...
Hello Antonio, Thanks for your inquiry and sorry to hear about your issue with SQL Prompt. Can you confirm if you've uninstalled SQL Prompt from Control Panel/Programs and Features? Can you confirm if you still have any leftover folders and files from the following directories? C:\Users\username\AppData\Local\Red Gate\SQL Prompt 10 C:\Program Files (x86)\Red Gate\SQL Prompt 10 C:\ProgramData\Red Gate\SQL Prompt 10 Thanks! / comments
Hello Antonio,Thanks for your inquiry and sorry to hear about your issue with SQL Prompt.Can you confirm if you've uninstalled SQL Prompt from Control Panel/Programs and Features?Can you confirm if...
Hello Rob, Thanks for the update on your end. We would recommend acquiring and decoding the JWT Token to make sure your inputs for the OIDC page in Redgate Monitor are correct based on what's being returned by the token. You can do so via the following directions: 1. Open your browser to a blank tab and then open the developer console (usually f12) then click onto the network tab and click the box to "Preserve log" [image] 2. Navigate to the SQL Monitor URL, one of the entries should be the OIDC request back from your OIDC provider. 3. Now click on the openidconnectaccount entry[image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] 4. In the Headers tab that is automatically selected scroll to the bottom and see if it has a section for Form data and an entry named id_token: [image] [image] That will have the content of whatever is returned from your OIDC provider. In the case above, the id_token is the JWT token that contains the information 5. You can then copy the value and enter it into a page such as https://adfshelp.microsoft.com/JwtDecoder/GetToken to decode the token and see what was returned. [image] Please let us know if that helps you out. Thanks! / comments
Hello Rob,Thanks for the update on your end.We would recommend acquiring and decoding the JWT Token to make sure your inputs for the OIDC page in Redgate Monitor are correct based on what's being r...
Good Morning! Thanks for your inquiry and sorry to hear about your issue with Redgate SQL Backup. Can you confirm the specific version of SQL Backup 10 that you're using? / comments
Good Morning!Thanks for your inquiry and sorry to hear about your issue with Redgate SQL Backup.Can you confirm the specific version of SQL Backup 10 that you're using?
Hello Glenn, Thanks for your inquiry with SQL Clone. This should be possible via the RedGate.SqlClone.Client.Api.Objects.ModificationScriptResource modifications parameter mentioned in this page: https://documentation.red-gate.com/clone/automation/powershell-cmdlet-reference/new-sqlclonetemplate| You can see an example of this in action below via Example 5: https://documentation.red-gate.com/clone/automation/powershell-cmdlet-reference/new-sqlcloneimage [image] Connect-SqlClone -ServerUrl 'http://sql-clone.example.com:14145'$SqlServer = Get-SqlCloneSqlServerInstance -MachineName 'WIN201601' -InstanceName 'SQL2016'$ImageDestination = Get-SqlCloneImageLocation -Path '\\red-gate\data-images' $maskingScript = New-SqlCloneSqlScript -Path \\red-gate\data-scripts\mask-emails.sql$permissionsScript = New-SqlCloneSqlScript -Path \\red-gate\data-scripts\change-permissions.sql $ImageOperation = New-SqlCloneImage -Name "AdventureWorks-$(Get-Date -Format yyyyMMddHHmmss)" `-SqlServerInstance $SqlServer `-BackupFileName @('\\red-gate\backups\AdventureWorks-201701012210.bak') `-Destination $ImageDestination `-Modifications @($maskingScript, $permissionsScript) $ImageOperation | Wait-SqlCloneOperation[image] [image] [image] [image] [image] Please let me know if you have any other questions or concerns on this.
Thanks! / comments
Hello Glenn,Thanks for your inquiry with SQL Clone.This should be possible via the RedGate.SqlClone.Client.Api.Objects.ModificationScriptResource modifications parameter mentioned in this page:http...