I had this same issue with one of my db. Apparently I had left Truncate log script for this particular db which fired before my Transaction Log backup script. Forgot...

Appreciate your help, will do so.

Check out this article:

http://www.sql-server-performance.com/tp_analyzing_sql_server_2000_data_caching.asp

I'm running this proc in SQL 2000 env and it works.

Not sure if I understand ur ?

The above mentioned proc will calculate how much the log file can be shrunk and then shrink it to that value.

This proc is run...

Run sp_configure proc and check out for Max Degree of Parallelism. For further info on this , Books Online is a good resource.

Run sp_configure proc and check out for Max Degree of Parallelism. For further info on this , Books Online is a good resource.

The following Stored Proc will Shrink the Log file to it's minimum value possible for the Database passed in as a Parameter to it.

exec dbo.Run_DBCCWithParam 'Target Database'

I have scheduled...

Phill/Peter Appreciate your response.

%1 worked!!!

Thanks.

Appreciate the response guys.

I will try this out and keep you posted with any update(s).

I ran into this issue too. Found this that helped me a whole lot:

http://www.sqldev.net/xp/xpsmtp.htm