Comments
Sort by recent activity
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...
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...
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...
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...