By the way, there are indexes on the tables that are created newly

Ali

But, How is that linked with the update stats failing over a non-exsisting table?

Ali

ok, I got that.

Do you have any thoughts on my error message.

Please let me know

Thanks

Ali

The above query on my deleted table is givng this message as expected

"Msg 2501, Level 16, State 45,...

Thanks for your early reply.

do you...

I have changed my recovery model to simple, took a full backup of my database, shrunk the database, ran rebuild and update stats. I recovered my space. i don't need...

Hey Jeff,

I am really sorry and I am really thankful to you. I never thought of being arrogant. I was really in urgency to know what's going on in...

I have a gut feeling that we really don't need Full recovery model. Now,I would like to take the full backup followed by log backup and then change the recovery...

Any Suggestion Sir.

Ali

42.04962GB --LDF

46Gb --Total

4.41632GB-- MDF

Actually, we dont take any log backups. All we do is daily full backups. Also, the recovery model is Full. I know everything is smelling weird. But,...

Also, in sys.databases, the log_resuse_wait is showing 2 and log_resuse_wait_desc is showing log_backup. Can you advice what is the course of action for this. I read in one article that,...

Thank you for your immediate response.

Yeah, at that point of time there was no other go for us. So I shrinked the t-log. i was able to recover 3gb. when...

Please advice Immediately.

Thanks

Ali

I am also facing the same problem. Today, our disk which holds the LDF's ran out of space, as a temporary action, I ran shrink on ldfs through management studio...

Yes Sir!! got it. I will work on it.

Thank you very much.:-)