When running the Maintenance Plan Wizard to shrink a DB ... I am selecting all databases, however I have it set to shrink only when it grows beyond a specific size.

If a database grows beyond a specific size will that trigger all the databases to shrink or only the one DB that was that size?

Also do you recommend returning the space to the OS or the DB file?

Thank you.

  • Why did this get voted down? – Rickie Feb 22 '16 at 16:00
  • 1
    Shrinking a file should be an exceptional, rare event. Not something you automate. Please read this. – Aaron Bertrand Feb 22 '16 at 17:06

To answer your question, that "all databases" selection will apply the size-monitoring to all databases, it will not shrink all databases when one grows too big.

Shrinking databases is usually not recommended, as Julien pointed out; especially on an automatic basis. I have shrunk databases before but always manually, after carefully evaluating "why" it needs to happen.

Related Q & A:

When is it OK to shrink a Database?
Should I shrink my database?

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.