Hi,
I'm trying to produce a report for all SQL servers backup up with TDP, which should include the space reserves available for each DB, in case of a TSM disaster/failure.
In other words, I need to know for each of the Databases its average use of transaction logs, so that I can calculate how long that DB could run, staying in Full Recovery mode while the TSM backup is unavailable, considering its current disk space and limits.
Does anyone know a relevant SQL command or tool to see statistics of this sort, in order to understand how much transaction logs does a DB create every day on average?
Thanks,
I'm trying to produce a report for all SQL servers backup up with TDP, which should include the space reserves available for each DB, in case of a TSM disaster/failure.
In other words, I need to know for each of the Databases its average use of transaction logs, so that I can calculate how long that DB could run, staying in Full Recovery mode while the TSM backup is unavailable, considering its current disk space and limits.
Does anyone know a relevant SQL command or tool to see statistics of this sort, in order to understand how much transaction logs does a DB create every day on average?
Thanks,