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

learn more… | top users | synonyms

0
votes
2answers
47 views

Is Data Purged when a site is removed?

So I have been asked the following question: When a site collection or one of it's web sites are deleted, is this data purged from the database, or is this data otherwise marked as deleted but kept ...
0
votes
1answer
2k views

Why SharePoint is not considering 'dbo.AuditData' table while calculating the site-collection size?

We have a heavy used site collection with a 30GB quota limit on the content DB - WSS_WebApp_Content1, I have verified the 'dbo.AuditData' table and found that it has 1.4c records and is 35 GB in size. ...
14
votes
4answers
2k views

Any reason not to create a new content database for each site collection?

When creating a site collection in stsadm there are 2 commands I could use: createsite and createsiteinnewdb, where the latter creates a new content database for the site collection. Reading around ...
2
votes
2answers
681 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 ...
1
vote
6answers
4k 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
303 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
55 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
257 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
462 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
195 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
448 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
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 ...
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
116 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
2answers
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
632 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
94 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
312 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
775 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. ...