Actually I do not have those mdf and ldf files to put back

Thanks Roy for your comments. But will the data get in sync with the approach you mentioned? I tried but the problem, data is not getting in sync.

Ziljan

Thank you so much for your response. Backup and Restore seems like a good idea but I have to add new articles to the publication, and hence generate a new...

Thanks Mauro and Brandie for your comments. The server is 64 bit and the OS is recognizing the memory. It showing what the system has.

Thanks again.

ALTER INDEX

REBUILD WITH (ONLINE = ON)

actually helped to defragment most of indexes in my databases, but when I tried this query in one of my database,...

Thank you so much for your reply.

I tried to use the script but it gave me the following error.

Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42

profile name is...

Probably you might have too many SQL connections, and it has been able to load all the connections, so it is timing out.

try SP_who2 gives you same information.

Micorsoft SQL Server 2005 SP3 will be available pretty soon.

Thanks for the valuable comments.

Chirag, could you provide me little more detail on figuring out blocking by using activity monitor?

Thanks

Can activity Monitor be handy in detecting the blocking? If so how?

Thanks

Thank You again for clearing some misunderstandings.

So, can I conclude that the only way to resolve the growing log is to take T log back up which truncates the...

Thank you so much for your time and effort. Like most of you said taking transaction log back up truncates the inactive portion of log and shrinks the t log...