Activity overview
Latest activity by Mac_F
Hello, You should be able to restrict suggestions for certain schema's in SQL Prompt Options by using Connections -> Specifiy the databases you want to load suggestions for: This should only load suggestions for the schema's you specify, and then load suggestions for the objects in those schemas. Here is our documentation on how to use this option: https://documentation.red-gate.com/sp/managing-sql-prompt-behavior/managing-connections-and-memory#Managingconnectionsandmemory-ManagingdatabaseconnectionsManagingdatabaseconnections I hope this helps. Kind regards, / comments
Hello,You should be able to restrict suggestions for certain schema's in SQL Prompt Options by using Connections -> Specifiy the databases you want to load suggestions for:This should only load sug...
Hello, Thank you for your question regarding SQL Monitor. The requirements have changed between version 8 and version 9 of SQL Monitor. For your current version (v.8), you will need the following to monitor the host Windows Machine:
The account should be an administrator on the remote Windows host machine.
The account should have login rights locally on the machine where the base monitor is installed, so that SQL Monitor can authenticate the account.
This does not necessarily require you to use a domain admin, but the account will need local admin permissions. For version 9 of SQL Monitor, you can connect to a Windows Machine without using admin permissions. You can find those requirements here: https://documentation.red-gate.com/sm/getting-started/requirements/permissions#Permissions-MonitoringhostWindowsmachineswithoutadminpermissions I hope this helps! Kind regards, / comments
Hello,Thank you for your question regarding SQL Monitor. The requirements have changed between version 8 and version 9 of SQL Monitor. For your current version (v.8), you will need the following to...
Hello, Thank you for your question. We are currently checking on this to see if it is possible, however so far we do not believe it is. We will let you know as soon as we can find an answer. Kind regards, / comments
Hello,Thank you for your question. We are currently checking on this to see if it is possible, however so far we do not believe it is.We will let you know as soon as we can find an answer.Kind rega...
Hi Carmine, Thank you for your question regarding SQL Clone. I believe the script we have listed in our documentation should be able to achieve a refresh of all the clones linked to an image: https://documentation.red-gate.com/clone/automation/powershell-worked-examples/refresh-all-clone-databases-to-use-an-updated-image You would just want to automate a nightly image creation from Prod first, and then use the script on the newly created image. Looking into the script, it looks like it should keep the same database names for the clones. In addition, there is also an article on Scripting Custom SQL Server Clones: https://www.red-gate.com/hub/product-learning/sql-provision/scripting-custom-sql-server-clones-for-database-development-and-testing?product=sql-clone Can you please test these and let us know if it works for your set up. Kind regards, / comments
Hi Carmine,Thank you for your question regarding SQL Clone. I believe the script we have listed in our documentation should be able to achieve a refresh of all the clones linked to an image:https:/...
Hi, I am sorry to see you have run into this issue with installing SQL Prompt. Could I ask you to navigate to http://localhost:22221/redgate/status.html and look to see which version the Redgate Client is running on? It should show at the top of the page. After that, would you click Check for Service Updates at the bottom? This should update the Client Service to the latest version. Thank you and my apologies for the inconvenience. Kind regards, Thank you, Mac Frierson / comments
Hi,I am sorry to see you have run into this issue with installing SQL Prompt.Could I ask you to navigate to http://localhost:22221/redgate/status.html and look to see which version the Redgate Clie...
Hi Jay, Thank you for your comment regarding SQL Monitor. At this time we do not have any plans to support Hyperscale. I see you have already opened a user voice forum post, as this is still the best way to add recommendation for our products. My apologies as I know this is not the answer you were looking for. Thank you, / comments
Hi Jay,Thank you for your comment regarding SQL Monitor. At this time we do not have any plans to support Hyperscale. I see you have already opened a user voice forum post, as this is still the bes...
Hi Katte, Thank you for your question regarding SQL Change Automation. We have opened a support ticket for your request, and you should have received and email about it. Would it be possible to obtain a copy of the full build log for the process? Can you please attach it to the ticket we opened for you? This will help us locate the cause of the problem. Thank you, / comments
Hi Katte,Thank you for your question regarding SQL Change Automation. We have opened a support ticket for your request, and you should have received and email about it.Would it be possible to obtai...
Hi, Thank you for your question regarding SQL Data Generator. Unfortunately, we do not yet know enough information about your scenario to make any good suggestions yet. We have opened a support ticket under your email address as your product is under support. We have sent you an email through that ticket requesting more information on your specific scenario. Can you please respond to that ticket? Thank you, / comments
Hi,Thank you for your question regarding SQL Data Generator. Unfortunately, we do not yet know enough information about your scenario to make any good suggestions yet. We have opened a support tick...
Hi svollhardt, Thank you for your question about SQL Backup, and sorry to see that you are running into trouble with seeing the backup history/logs from your older version. Unfortunately, you will not be able to install the SQL Backup 7 GUI alongside the SQL Backup 10 as it will always force an upgrade. For the your newer installation of SQL Backup with v10, can you please double check that you have upgraded the activity cache successfully when the new version was installed? [image] Even with a newer version of SQL Backup GUI it should still be possible to see the activity history of the jobs from an older version installation of the SQL Backup server components. [image] You can try recreating your activity cache with the steps below to see if that helps:
Close the SQL Backup GUI
Navigate to this directory on the machine where the SQL backup GUI is installed: C:\Users<username>\AppData\Local\Red gate\SQL Backup\ServerData
In this folder you will find one or more .dat files, for example 1.dat, 31.dat, localDataCache.dat.
Delete all the *.dat files in the ServerData folder.
On the machine where the SQL Instance is located stop the SQL Backup Agent service.
Locate the SQL BackupLocal Data Store. The default path is as follows: C:\ProgramData\Red Gate\SQL Backup\Data<SQL Instance name>
Rename the existing data.sdf file to OLDdata.sdf.
Restart the SQL Backup Agent Service, this step will create a new data.sdf.
Now re-open the GUI. The *.dat files deleted in step 4 will be recreated. Are you now able to view the Activity History? Depending how much activity history there is you may need to wait for a while.
I hope this helps. Thank you, / comments
Hi svollhardt,Thank you for your question about SQL Backup, and sorry to see that you are running into trouble with seeing the backup history/logs from your older version.Unfortunately, you will no...
Hi Bob, Thank you for your questions regarding SQL Prompt. To answer your first question. You can disable the Tab History, so that the previous sessions tabs do not open when SSMS is opened. To do this. You can navigate to SQL Prompt menu -> Options [image] In the options menu, you can navigate to 'History' and un-check 'Enable tab history' [image] You can find more information on Tab history here: https://documentation.red-gate.com/sp/ssms-tab-management/tab-history For your second question, the way to turn off SQL Prompt in SSMS is to log out of the license activation screen. You can do this by navigating to SQL Prompt menu -> Options -> Manage License [image] You will want to sign out in order to deactivate SQL Prompt [image] To reactivate SQL Prompt, you can use the same navigation path to sign back in. I hope this helps Thank you, / comments
Hi Bob,Thank you for your questions regarding SQL Prompt.To answer your first question. You can disable the Tab History, so that the previous sessions tabs do not open when SSMS is opened.To do thi...