btw -can we capture the log file too?

where do we add it on the script?

Thanks,

Susan

This script is very useful.

Thanks for that I can use this too for my server.

Yes I did it eventually

Thanks

Thanks Steve

Could you tell me how do I do that? or at least give me a start point. 🙂

Thanks

we setup in maintenance plan that every Sun - it will reindex/re-orgnize etc...

and also I notice this happens since we move from sql 2000 to sql 2005.

has anyone using navision?

If I am doing the work around and delete the ' NEW COMPONENT OUTPUT'

which one I should delete it. I have several txt file which are dated 4 oct.

and...

At the moment I will monitor it again Next mon.

I have changed my transaction log backup from 15 min to 5 min

Thanks guys

Thanks for the warning, Paul.:)

I may do it during weekend or when we are going to upgrade our apps

Thanks Andras.

I will do that.

one more questions.

when we swicth it, do we need to turn of the transaction log backup too?

currently the transaction log back up I change it to...

Thank your for your info.

I try not to use shrink file.

I guess I was a bit surprise when the log file is growing very large.

I will monitor it again and...

DB is about 45Gb.

I don't know which table has the largest index.

the apps is not developed by us.

thanks,

Susan

Sorry to confused you.

my recovery model is 'Full'.

in your article, you mention that one of way to avoid groing log file, we should switch to 'Simple' recovery.

however on my...

If " backup log [MyDatabase] with no_log " will be removed

and we use ' simple recovery backup

what happen if the DB need using Full backup recovery.

what is the solution for...

I am a bit confused...

my server is 9.0.3042 so I guess this is a SQL SP 2 already

however my clean up task especially for maintenance plan reports are not working.

After...