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)
This is a great article about SharePoint databases and maintenance plans:
http://technet.microsoft.com/en-us/library/cc262731(v=office.14).aspx
In terms of general SQL Server maintenance, i’m attempting to follow this:
http://www.houseofbrick.com/component/content/article/1/181-Routine-SQL-Server-DBA-Tasks
I don’t generally shrink data files btw.
(Visited 1 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)
