Database File Size Maintenance

This project is for development of a stored procedure, which is to be used as an add-on to Ola Hallengren’s maintenance solution, and retains the same standards and conventions in its implementation of parameters.

The DatabaseFileSizeMaintenance stored procedure focuses on managing database file size growth and shrink, based on specified parameters.

Please click above to visit the repository for more details.

Prerequisites

The procedure requires Ola Hallengren’s CommandExecute procedure in order to run.

If @LogToTable = 'Y' is specified, then you must also have the CommandLog table in the same database.

If @DatabasesInParallel = 'Y' is specified, then you must also have the Queue and QueueDatabase tables.

License

This project is licensed under the same open-source project as Ola Hallengren’s maintenance solution.

The DatabaseFileSizeMaintenance stored procedure is released under the MIT license.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.