Tagged Questions

11
votes
3answers
279 views

SharePoint database maintenance for the non-DBA

Question ported from Serverfault as it is specific to database maintenance for SharePoint administrators: For SharePoint administrators, SQL Server is often a black box that is installed as a ...
1
vote
3answers
295 views

How do I perform database disk usage analysis and selective replication?

I have a SharePoint 2007 database that is 16GB in size and I want to know why, and how I can reduce the size. Ideally I would like a trimmed replica to use as a developer workstation that retains a ...
3
votes
2answers
66 views

How critical is it and how to monitor, measure and reduce SharePoint database fragmentation?

It is a well advertised best practice to configure maintenance plans for SQL databases forming the data layer of SharePoint deployments. How critical is it to monitor and reduce fragmentation of the ...