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

learn more… | top users | synonyms

2
votes
1answer
877 views

Restore Content Database to a different farm (Prod -> Beta -> Dev Servers)

My end goal is to have some code that automatically takes the Content Database backup from Production and automatically nightly restores it on Beta. Can I just do backup and restore sql commands? Or ...
0
votes
1answer
475 views

Check if user has access to Content database in SharePoint 2010

In my code I'm running under elevated privileges, to access other Web applications. But I get a security error when the web application user can't access the database (when ever I try to access a ...
1
vote
1answer
91 views

Specific content datatbase for a site collection

We have two content databases in a webapplication. We would like to have a site collection in a content database (Content_DB1) and rest of the site collection should be created in the another content ...
0
votes
1answer
358 views

How to force Sharepoint to commit list item changes to the database?

Long story short, I have an event receiver on a list item which listens for the ItemAdded event, makes some additional changes to the newly created item, calls listItem.SystemUpdate() and starts a ...
0
votes
1answer
636 views

Database requirement for fast for sharepoint 2010?

We would like to install Fast for Sharepoint 2010 in our medium scall Sharepoint 2010 Farm and would like to know how many databases are required and what about the other Database requirements? I ...
1
vote
3answers
174 views

Accessing the content database directly

Is accessing a content database is not a 'best practice' or 'advisable' or it 'should' not be done as Microsoft can withdraw their support if it is done? I just want to know if it 'can' be done in the ...
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 ...
2
votes
2answers
2k views

Unable to complete this operation. Please contact your administrator

We are using one API SharepointImporter Tool to upload documents to a SharePoint Site. When we are uploading one archive file we are getting the following problem. Error: Unable to complete this ...
1
vote
1answer
349 views

Create List from Microsoft Access 2007 database in WSS 3.0 with sync capability

Is there an easier way to - Create a List from a database (.mdb) file on WSS 3.0 Once the list is up, I want to sync it with database. i.e. Any changes I make to the database file offline should be ...
2
votes
2answers
634 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 ...
1
vote
2answers
1k views

External database connection in web part

So, I have a web part that needs to connect to a different database other than sharepoint. This is a custom web part that I'm writing in VS, not something built with SPD. How can I connect to the ...
0
votes
2answers
306 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
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 ...
3
votes
3answers
808 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. ...
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
259 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 ...
3
votes
2answers
465 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
196 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
449 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
71 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
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 ...
4
votes
4answers
313 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 ...
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 ...