sql-server-maintenance-solution icon indicating copy to clipboard operation
sql-server-maintenance-solution copied to clipboard

Integrated reindex/backup option

Open daksatech opened this issue 4 years ago • 0 comments

Our DB server has thousands of small databases on it. We have a single reindex job scheduled followed by a backup job. We would ideally like to reindex a database then backup that database immediately after; then go to the next database and repeat the reindex/backup operation.

I could write a script to loop thro the databases and the call dbo.IndexOptimize followed by dbo.DatabaseBackup one database at a time. But it would be great to have an inbuilt option to call the reindex and backup scripts.

daksatech avatar Sep 13 '21 20:09 daksatech