We have a vcenter database on an AG setup. The log file keeps growing sometime due to metrics which are enabled on the application end. They will be moving this soon to another db vendor to probably mitigate the situation, but when I try to run tlog backup by myself it is taking hours to finish(this is not the case when I setup a scheduled tlog backup via sql agent) Also, when I try to shrink the log file after the backup, it is not getting shrunk. Is there another way to shrink the logs? Please let me know
Asked
Active
Viewed 15 times
