sql-server-maintenance-solution
sql-server-maintenance-solution copied to clipboard
Integrated reindex/backup option
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.