Comments
Sort by recent activity
Thanks Dan. The issue finally self-resolved. / comments
Thanks Dan. The issue finally self-resolved.
It's basically the same as it's using native compression. The main advantage is that it works in scope using the familiar SQL Backup interface. / comments
It's basically the same as it's using native compression. The main advantage is that it works in scope using the familiar SQL Backup interface.
I had to open a ticket with support and was finally able to get it to work, but there are a few hoops. They have fixed TDE to work using the SQLCOMPRESSION option and the Microsoft SQL Bug was fixed with a SP and CU some time ago. Please make sure you have a fairly recent SP/CU as you could have issues if you are using a version of SQL 2016 that doesn't have the fix, sorry I don't know the exact time it was fixed but you could look it up or just make sure your SQL Server patching is sufficiently up to date. You also need to add an undocumented key to the registry: REG_DWORD to HKLM\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(nameofinstance) called FORCETDECOMPRESSION with a value of 1. If you have further questions check with Red Gate support. / comments
I had to open a ticket with support and was finally able to get it to work, but there are a few hoops.They have fixed TDE to work using the SQLCOMPRESSION option and the Microsoft SQL Bug was fixed...
According to the latest release notes, TDE backup compression support was added with version 9.1.4. However I am running on version 9.2.7 and TDE backup compression on a SQL Server with 2016 SP2 CU2 is not working. For a sanity check, I was able to get TDE backup compression to work with native backup. Is this a bug? Should I test TDE backup compression on an earlier release of SQL Backup? Version 9.1.4 August 31st, 2017 This release of SQL Backup includes the following enhancements and bug fixes: Fixes
SB-5792 Support compression of TDE-enabled databases
SB-5808 Allow logging of data files.
SB-5810 Improved deleting of old backup files when using ERASEFILES syntax
Support for partial and partial differential backups in Restore Wizard in the GUI
Improved error reporting in the Restore Wizard
Update to UsageClient - can now cross NTLM secured proxies, and fix potential delays on shutdown
/ comments
According to the latest release notes, TDE backup compression support was added with version 9.1.4. However I am running on version 9.2.7 and TDE backup compression on a SQL Server with 2016 SP2 C...
That's fine. It's good to know that this was an intentional change. But it would have been nice to have included this in the release notes so that I wouldn't have wasted time trying out to figure out why the install switched to IIS. / comments
That's fine. It's good to know that this was an intentional change. But it would have been nice to have included this in the release notes so that I wouldn't have wasted time trying out to figure...
Thanks for finally getting back to me. But I still have to say "Oh Boo". That's unfortunate as I want users to be able to identify parameter sniffing issues, but I don't want them to have the ability to change configuration. / comments
Thanks for finally getting back to me. But I still have to say "Oh Boo". That's unfortunate as I want users to be able to identify parameter sniffing issues, but I don't want them to have the abi...
Thanks for clarifying. The fact that it's in the new preview version is good, but the new preview version doesn't show a 15 minute window like the classic view does. The smallest window the preview version allows is 6 hours. / comments
Thanks for clarifying. The fact that it's in the new preview version is good, but the new preview version doesn't show a 15 minute window like the classic view does. The smallest window the previ...
I am not seeing these vertical squares that would adjust the time slice to 15 minutes. But I did notice that it's a two hour slice as opposed to a six hour slice. / comments
I am not seeing these vertical squares that would adjust the time slice to 15 minutes. But I did notice that it's a two hour slice as opposed to a six hour slice.
Oh, I see them now. They are on the graph. Thanks. / comments
Oh, I see them now. They are on the graph. Thanks.
Thanks Alex
Just for clarification, for me the compatibility view settings were not explicitly assigned to the SQL Monitor web sites, but instead the option to use compatibility view for all intranet sites had been checked. / comments
Thanks Alex
Just for clarification, for me the compatibility view settings were not explicitly assigned to the SQL Monitor web sites, but instead the option to use compatibility view for all intran...