As my .ldf has become 140 gb and disk space is also 140 gb what I can do in this situation ?

First : - The query that is being...

Hi Gail,

I cannot contact to the remote user, as they are using some updates in db so I cannot kill the session as well. So , what shall I do...

HI Gail

Thanks for your stuffs.

Yes Gail, I want high level overview and here I am talking about truncate backup.

I want to know what exactly happens internally when these command get executed.

I want to know what exactly happens internally when these command get executed.

No compression on database files.

It is not live data I am practicing. Can I restore only that FG, from where the table got deleted. Else I need to restore all backups including full backup...

How can I get these CPU, Network & Memory details ? Can you guide me ?

Does this tracing gives the detail of that user who has deleted the Jobs in SQL server 2005 ?

Its academic only.

I meant exactly what happens that causes suspect mode to db?

No, actually one of interviewer asked me this question. And how can we resolve this torn page issue can we resolve this by using existing backup or do we need...

Thanks for your reply.

Thanks Gail, your efforts saved me from big problem. Thank you very much.