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)
“Shrinking data files” – I heard that you should never do that in a maintenance plan.
I have only full and incremental backups.
(Visited 1 times, 1 visits today)
