Comments
Sort by recent activity
Spam / comments
Spam
Not related to Redgate. / comments
Not related to Redgate.
Windows activator / comments
Windows activator
Nothing to do with Redgate. / comments
Nothing to do with Redgate.
Spam / comments
Spam
Hi @SirWill Thank you for reaching out. Below are the answers to your questions
Unfortunately, SQL Backup does not currently support QAT Compression. While there were discussions about adding this feature, it hasn’t been implemented yet I'm afraid.
Regarding Object Level Restores, this feature doesn't support that version of SQL Server, so It's not something I would feel confident in recommending: Object Level Recovery Limitations.
As for licensing, each server running SQL Backup Pro requires a separate license. Here's a summary from the documentation page: The SQL Backup Pro server components are licensed per server. In this context, a server refers to a distinct system running a Windows operating system, whether physical or virtual. If you have a number of SQL Server instances running on the same physical or virtual server, you only need one license to activate the server components on each of the SQL Server instances. If your servers are clustered, you will need a license for each node running SQL Server: SQL Backup Licensing Guide.
If you only have 1 active instance up at one time, then that must be licensed. It shouldn't affect things if you leave one which remains down unlicensed.
/ comments
Hi @SirWill Thank you for reaching out. Below are the answers to your questions
Unfortunately, SQL Backup does not currently support QAT Compression. While there were discussions about adding this ...
Hi @FredK I believe this is more of a failsafe to make sure that no changes are, if any were made. I'm afraid I don't have a way to turn that popup off. If it's a task you are running regularly, you could automate it through the command line. Simply save a batch file that contains the SQL Data Compare command. Set it up on an automated schedule (or even just execute it manually), and it will do the same process as what the GUI does. / comments
Hi @FredK I believe this is more of a failsafe to make sure that no changes are, if any were made. I'm afraid I don't have a way to turn that popup off.If it's a task you are running regularly, you...
mashal1st did raise a support ticket and we managed to get it resolved by inspecting the various configurations in the SQL Prompt > Options. We found the culprit were these two options (Apply layout (format SQL) and Apply casing options). After enabling both, the formatting worked as was expected. [image] [image] / comments
mashal1st did raise a support ticket and we managed to get it resolved by inspecting the various configurations in the SQL Prompt > Options. We found the culprit were these two options (Apply layou...
@mashal1st My apologies for the delay. So it works to a very small degree? Would you be able to share an example of the sort of queries you are trying to format? I may have to do some testing on my end to see what is going on. If you're not happy to share a query here, you're more than welcome to email support@red-gate.com, which will create a support ticket. If you could also include your formatting file (default location here: C:\Users\user_name\AppData\Local\Red Gate\SQL Prompt 10\Styles), and your SQL Prompt options file, that would be helpful for the testing. You can export the options file from SQL Prompt tab > Options > Export. On the topic of the styles, do any of the other default formatting styles make any meaningful changes? / comments
@mashal1st My apologies for the delay.So it works to a very small degree? Would you be able to share an example of the sort of queries you are trying to format? I may have to do some testing on my ...
Hi @mashal1st Can you expand further on the formatter not working? Does it simply do nothing, or does it throw an error? Do any other functions within SQL Prompt work, such as code suggestions? Could you try uninstalling and reinstalling the latest version? https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.23.11448.exe / comments
Hi @mashal1st Can you expand further on the formatter not working? Does it simply do nothing, or does it throw an error? Do any other functions within SQL Prompt work, such as code suggestions?Coul...