Activity overview
Latest activity by ClarkChris
I was using the obfuscated password in my @EncryptionKey = 'ola5dKAWc3PuvU5k' and this wouldn't decrypt. When I use the plain text @EncrytionKey = 'TestPassword' then it works fine. Thank you / comments
I was using the obfuscated password in my @EncryptionKey = 'ola5dKAWc3PuvU5k' and this wouldn't decrypt. When I use the plain text @EncrytionKey = 'TestPassword' then it works fine. Thank you
Yes, I am creating the full backups using the Ola Hallengren solution, and then attempting to restore using Redgate SQL Backup. I have not been able to restore with T-SQL either. The password doesn't decrypt. / comments
Yes, I am creating the full backups using the Ola Hallengren solution, and then attempting to restore using Redgate SQL Backup. I have not been able to restore with T-SQL either. The password does...
Configuring Encryption using the Ola Hallengren Backup Solution
I am unable to restore the full backups (the key doesn't decrypt the full backup when using Redgate SQL Backup). Here is the example of the backup script:EXECUTE [dbo].[DatabaseBackup]@Databases =...
Our full backups just started failing with the follow Error: BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_0F1A69BB-FE8D-4475-A5FD-4C1C6DB10C8602'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). [image] Please advise on the best way to correct this error. / comments
Our full backups just started failing with the follow Error:BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_0F1A69BB-FE8D-4475-A5FD-4C1C6DB10C8602'. Operatin...
Fellow DBA Anup Pudasaini determined how to configure Redgate's 'SQL Monitor 4' to allow several users to login from separate workstations using multiple webservers. Anup added an additional step, along with the following notes to the procedure Redgate had posted:
Configuring multiple webservers for the SQL Monitor:
To be able to launch and use ‘SQL Monitor 4 Website’ API from your individual machine, you need to configure your local machine to host the webserver for SQL Monitor.
You might be getting this error message when you first try to connect to the base(monitoring server)-
SQL Monitor displays this error when you try to connect from a web server that the base monitor doesn't recognize.
To fix the problem, pair the base monitor with the new web server.
Once you pair the base monitor to a new web server, you won't be able to connect using the old web server. To preserve existing webserver connection, save the guid string from the RedGate.Response.AuthorizedClients.config from below somewhere and make sure all connections are logged off.
1. On the machine running the base monitor, go to %ProgramData%Red GateSQL Monitor 42. Delete RedGate.Response.AuthorizedClients.config
3. On the web server you want to use, open the SQL Monitor web interface and connect to the base monitor.
This pairs your current web server to the base monitor.
4. Add back the existing guid string to preserve the existing webserver connection.
Now you should have successful connection between your machine and the base server.
You would still need to provide your logon and password to actually view the dashboard. / comments
Fellow DBA Anup Pudasaini determined how to configure Redgate's 'SQL Monitor 4' to allow several users to login from separate workstations using multiple webservers. Anup added an additional step...
Multiple Webservers for SQL Monitoring Service
We have 3 DBA's that would like to use the SQL Monitoring Webpage from their individual workstations. Is it possible to configure multiple webservers for one SQL Monitoring Service Account? If n...
Thanks Rick for the information. Regarding the password, I wanted to ensure that the newer version of Redgate Backup Pro would be able to decrypt the password provided in the earlier version... that the decryption algorithm would properly decrypt and accept the 'password'. / comments
Thanks Rick for the information. Regarding the password, I wanted to ensure that the newer version of Redgate Backup Pro would be able to decrypt the password provided in the earlier version... th...
Restoring Older Versions of Redgate Backups
Is it possible to restore a Full Backup taken using Redgate SQL Backup Pro Version 6.5 with Redgate Backup Pro 7? Also, is there any impact in validating the same encrypted password between the t...