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?
If you use Availability Groups, all your databases are in Full Recovery mode. That means logs get pretty big.
If you never Shrink, log files will get huge.. and unfortunately for some companies, space is an issue.
I am trying to find a correct order in which to do them.. What do you think of this? (Every Night)
1. Check Database Integrity.
2. Full Backup.
3. Shrink Logs.
4.Reorganize Index
5. Rebuild Index.
6. Maintenance Cleanup Task.
Adapted from this link: http://social.technet.microsoft.com/wiki/contents/articles/13956.sharepoint-2010-how-to-create-a-sql-server-2008-r2-maintence-plan-for-sharepoint.aspx
