search

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.88k stars 739 forks source link

Maintenance Script #350

Open aslam2510 opened 4 years ago

aslam2510 commented 4 years ago

Hi Ola,

Thanks for your wonderful scripts. Need little clarification and steps to use only Rebuild and Reorg index and update statistics script. do I have to execute all the scripts or if I use only DB Maintainance script is more than enough.

bburhans commented 4 years ago

@aslam2510: The scripts install the procedures. MaintenanceSolution.sql rolls up the other scripts into one so you don't have to execute the others individually. By default, it creates SQL Agent jobs you can use to run any or all of the procedures on a whim or on a schedule.

The documentation for this project is not currently in the repository; it lives on the web site linked in the README, at https://ola.hallengren.com/. Check there for clarification on the options and features.