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)
If you’re using availability groups, you HAVE to be on FULL on all databases!
(Visited 1 times, 1 visits today)
