Activity overview
Latest activity by jlray
Thanks for the info! / comments
Thanks for the info!
High Fragmentation on SQL Monitor Repository Tables
The SQL Monitor Repository/DB is on one of the servers being monitored by SQL Monitor. Some the indexes on the repository tables are generating fragmentation alerts. The offending indexes are alm...
Yes, I was able to change password in the Server/Instance registration via the GUI but that password does not propagate to the backup service running on the server. https://documentation.red-gate.com/sbu/permissions#Permissions-ChangingtheSQLBackupAgentservicecredentials From the documentation: If you are using SQL Server authentication and you change the account password, you must also apply the change to the SQL Backup Agent service, otherwise backups and restores may fail. This can be done using the sqbsetlogin stored procedure as above, but specifying the new account credentials on step 2. I did the above and restarted the service but the service still did not use the new password. So far, I've had to reinstall the backup service on 2 servers because the services would not recognize the password change. / comments
Yes, I was able to change password in the Server/Instance registration via the GUI but that password does not propagate to the backup service running on the server. https://documentation.red-gate...
Yes, I was able to change password in the Server/Instance registration via the GUI but that password does not propagate to the backup service running on the server. https://documentation.red-gate.com/sbu/permissions#Permissions-ChangingtheSQLBackupAgentservicecredentials From the documentation: If you are using SQL Server authentication and you change the account password, you must also apply the change to the SQL Backup Agent service, otherwise backups and restores may fail. This can be done using the sqbsetlogin stored procedure as above, but specifying the new account credentials on step 2. I did the above and restarted the service but the service still did not use the new password. So far, I've had to reinstall the backup service on 2 servers because the services would not recognize the password change. / comments
Yes, I was able to change password in the Server/Instance registration via the GUI but that password does not propagate to the backup service running on the server. https://documentation.red-gate...
Yes, I was able to change password in the Server/Instance registration via the GUI but that password does not propagate to the backup service running on the server. https://documentation.red-gate.com/sbu/permissions#Permissions-ChangingtheSQLBackupAgentservicecredentials From the documentation: If you are using SQL Server authentication and you change the account password, you must also apply the change to the SQL Backup Agent service, otherwise backups and restores may fail. This can be done using the sqbsetlogin stored procedure as above, but specifying the new account credentials on step 2. I did the above and restarted the service but the service still did not use the new password. So far, I've had to reinstall the backup service on 2 servers because the services would not recognize the password change. / comments
Yes, I was able to change password in the Server/Instance registration via the GUI but that password does not propagate to the backup service running on the server. https://documentation.red-gate...