Thanks for your reply. Next time I will post the questions as per your suggestion.

Hi,

Thanks for your reply.I have a change order to shrink all the databases in one server.Before doing that i need to lock the databases from Users. All these for...

that is ok.i enabled auto shrink option,but why that is not happening once the log file is grown extremely..please let me know...

Yes.DB Recovery model is Full.Even Auto Srink option is also enabled.the database is in Sql Server 2000.

I am not able to set the DB to Multi_User mode.I have the backup file with me,If I want to delete the DB also I am unable to do it.Getting...

Thanks allot for your reply..

Thanks allot for your reply.