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)
We backup logs every 15 minutes or so, so our logs are never that big. (relatively)
I’d thus remove step 3, and if you are rebuilding indexes why would you reorganize them? (Unless they’re different indexes.)
As you say, space can be an issue, but unless you’re willing to loose data I wouldn’t set the mode to simple, or not have hourly (at a minimum transaction log backups.)
Â
Â
(Visited 1 times, 1 visits today)
