Hello Everyone,
I am wondering what do other people put in their SQL Maintenance plan for SharePoint Databases. Â What operations do you do, in what order?
For Example,
- Check for and repair consistency errors by using dbcc checkdb
- Full Backup
- Measure and Reduce Fragmentation
- Fine tuning index performance by setting fill factor
- Shrinking data files
What’s on your plan?Â
(Visited 297 times, 1 visits today)
mostly agree with your list.
But I would shrink logs only together with an intelligent sizing afterwards. (what I mean is, resizing the files to prevent autogrowth as much as possible)
(Visited 1 times, 1 visits today)
