0

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.

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

1 Answer 1

2

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?

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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