Thank you 🙂

Interesting, I never thought of this. I thought it is per year.

Another advantage is in companies which have dedicated teams for managing SSIS packages and database engine. In these cases, if we have a separate instance for SSIS packages then the...

I am not sure if you have tried using the below DMV's for querying tempdb.

You may try to collect some information as well from the below.

sys.dm_db_file_space_usage

sys.dm_db_task_space_usage

sys.dm_db_session_space_usage ...

Yes Gail, I agree with you.

We could information related to object creation, object deletion etc. but not DML.

I think the default trace must be running on your instance. This usualy rolls over after around 20 MB.

If the deletion happened recently, may be you could find what...

Please post the exact error message.

Thank you Ron

You could use some DMVs to find out what exactly is consuming space in tempdb among these : - user objects, internal objects, and version stores

Below DMV's will give you...

Very good effort Ron. You have handled a tough topic with lot of care. Thanks.

Taking FULL backup of database will...

I messed up the earlier quote option

[/quote]

But what...

Yep,

If you database log file still online/accessible ,then you can take the tail of log and you can restore the PIT..[/quote]

But what if the log backup that you already have...

I think I confused the question. Here, the transaction log backup itself is corrupt. Is it possible to rectify the corruption in the transaction log and still use the log...

Thank you for clarifying.