So every one concur that maintenance is some thing that we should dump away and use scripts

so if maintenance plan dont work should we at least know the reason...

Never use maintenance plans for reindexing -

I was wondering why ? if the option is there and we have one database why maintenance plan wont suffice for that operation ?

so...

Ed Wagner (1/6/2016)

---

Hugo Kornelis (1/6/2016)

---

The statement "doesn't work or doesn't work well" is invalid.

But if you ask which is better, then my guess is that 99% of the experts will...

I mean if its for some thing like checking database integrit and reindexing which one is better I know you get more control with the script but I just...

I think I m doing it right but still the task doesnt delete the files after the backup is completed

Some one mentioned the security of the backup folder how...

no issues just want to wanted to have 50 MB

OK great thanks for the script it diffidently great

However when you said the default is a so does that mean I will have 2 traces running or...

Can you please post the script I want to see a sample so I can modify the file size

What if I want to change the size limits of the file to 50 MB for example is it also a default can not be changed ?

Found out this good link thank yo guys

http://www.mssqltips.com/tip.asp?tip=1111

Thanks yes I see it here on the screen shots from this site

http://www.bradmcgehee.com/2010/01/how-to-use-sql-backup-inside-a-maintenance-plan/[/url]

I think what you meant is enabling trace logs and this can be done through service profiler I think

Apologize I created a maintenance task to backup my MSSQL database and I realized that that I need to encrypt it before I put the file to a...

Is there a way that we can automate this through maintenance task ?