I have Veeam v8 installed. The Veeam Backup DB is installed locally on the Veeam server on sql server 2012. No other instance or database is installed on this sql.
The tempdb (system db that sql creates during installation) is still growing and now is around 70 GB. I have read that this tempdb is used for temporary transactions and should return to normal size when those transactions are done. I also read that some applications fail to "tell" this tempdb that the transactions are done and that's why it keeps on growing, and upon restart of the server, tempdb should return to normal size.
I did restart the server, however, tempdb is still 70GB.
I need to know how to fix this.
Is this an issue related to Veeam 8.0?
If I upgrade Veeam to 9.5, will this issue be solved?
Any help is much appreciated!