A usually large collection of data organized especially for rapid search and retrieval (as by a computer).

learn more… | top users | synonyms

2
votes
2answers
852 views

(De)Commission SharePoint Database Servers

In our SharePoint Farm, We are running with 2 Database Servers and on which we have 20+ Databases.Now, due to some issues we would like to decommission the existing database servers and commission 2 ...
2
votes
6answers
6k views

Emptying site collection recycle bin doesn't make content DB smaller?

I deleted everything from a site collection recycle bin and remote into the SQL server the content database is located and the sucker didn't get smaller. I had about a good 2 or 3 gigs of files in the ...
0
votes
2answers
335 views

Issue when trying to reinstall MOSS on a single server

I am not an expert on the installation of SharePoint, but I have been trying to configure the MOSS installation on one of our DEV servers. The first problem was found when trying to set up an SSP. ...
0
votes
1answer
56 views

Performance Metrics and CA Configuration & Content DB?

When can we expect a maximum number of SQL connections for the Central Administration Configuration & Content DB? and what are all the important tables in these databases that an administrator ...
0
votes
1answer
271 views

Performance tuning and Manage Farm-Level Search Settings

Below options are available under "Manage Farm-Level Search Settings" in Central Administration Connection time (in seconds): 60 Request acknowledgement time (in seconds): 60 I would like to know ...
2
votes
5answers
5k views

Guidance on renaming the multitude of databases generated by SharePoint 2010

SharePoint 2010 appears to continue SharePoint 2007's tradition of automatically creating horribly named SQL Databases. Like many companies we have multiple farms and developer workstations connecting ...
3
votes
2answers
470 views

What is the use of the search database and do we really need it?

The index will be kept on the Index Server, so why do we need a Search database and what is the point of it in SharePoint 2007? I would like to understand the basic concept of SharePoint Search. ...
3
votes
2answers
202 views

How can I create a web part for add update and delete operations?

I'm new to SharePoint and I'm working with web parts. I have learned how to create a basic webpart and how to deploy it...but I don't have any ideas about how to create a web part that adds updates ...
1
vote
1answer
463 views

Managing Quotas and Content Databases with multiple Site Collections

Five content DBs are associated with a webapplication and each content DB can store upto 50GB. We have configured a couple of site quotas as follows: basic_quota (1GB) collab_quota (2GB) ...
2
votes
5answers
2k views

Migrating content from one content database to another

We have a content database on our live moss server. It contains one site collection with several sub-sites. I'm using the stsadm export command to produce a cmp file, then moving this to our test ...
3
votes
2answers
79 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 ...
1
vote
2answers
3k views

Web Front End servers in the server farm are not consistent in the services they run

I have successfully configured a SharePoint farm of 4 nodes but I got intermittent database connection failure errors. I have to restart SharePoint services and IIS to fix the database errors. Mostly ...
1
vote
2answers
119 views

Extra database server in farm

Recently I was looking at Central Admin > Operations > Servers in Farm and noticed an extra database server. It is the same name as the actual database server with "-Common" appended to the end. This ...
1
vote
3answers
2k views

Why EventCache table size is huge

I have a MOSS publishing site. Content is quite small. I noticed that content database size is now 5GB without any significant content changes made. Using a script to show the tables' sizes, I noticed ...
2
votes
2answers
651 views

Restoring SSP Databases from SP1 to SP2 server farm

Has anyone restored Shared Services Databases from SP1 Server Farm to a new SP2 Server farm? I don't want to lose user related information link My Links etc. I followed the DB attach method as ...
2
votes
2answers
1k views

Changing to SQL alias after installing MOSS

Our network admin installed MOSS using the SQL Server address instead of using the SQL alias. How can we change this after the fact? We tried using a simple stsadm commmand to change server name but ...
2
votes
1answer
97 views

Running code that creates a TimerJobDefinition outside of Central Admin

I have run into a problem several times now where I have developed a custom timer job, and I want my site collection administrators to manage the schedule of this job with a custom application page ...
4
votes
4answers
320 views

How does SharePoint handle unreliable database connections?

Background We're experiencing network issues with connections to our SQL box unexpectedly being closed. These are occurring a few times a day. Errors are being logged by the SharePoint WFEs but users ...
3
votes
3answers
902 views

Databases from 2 SharePoint servers on the same database server?

I've got 3 servers: - DB1 - SharePoint1 - SharePoint2 On SharePoint1 I've installed WSS, using DB1 as database. Now I want to install WSS onto SharePoint2 and use DB1 as database storage as well. ...