0
votes
0answers
47 views

Sharepoint 2013 database maintenance

I have debugged my solution over and over again. I have installed new site collection and I have remove those. Today, central administration had message: "Missing server side dependencies." I made ...
0
votes
3answers
164 views

What is best way manage SharePoint webpart access to database?

I have my custom webpart, which have access to database. I need to configure data source, catalog, username and password, which allows webpart a access database. I don't want that users can see, what ...
11
votes
3answers
400 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
320 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
70 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 ...