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
71 views

SP2010 Display data from a database with List controls

What would be the best/easiest way to retrieve data from a database (Customer info) and display it on a custom page but with the controls of a list: like sort, filter, views and search in the list? ...
0
votes
4answers
361 views

Replicating database tables as SharePoint lists

We have a legacey application that is running with a SQL backend. We want to end of life the old application and use SharePoint 2010 instead. In my my mind we have a few options of what we could do. ...
1
vote
2answers
1k views

How can I solve “A SharePoint database named [xxx] already exists” when upgrading from SharePoint 2003 to 2007?

I am trying to upgrade a SharePoint 2003 web application to MOSS 2007 through the database attach method. I am following these steps as outlined by Microsoft: Create web application in MOSS 2007 ...
6
votes
1answer
2k views

Splitting a Content Database into two or three?

I have a SharePoint Farm in which the main Portal Web Application uses a single WSS_Content database, which has grown a lot to about 150 GB. I know I can now put it offline and attach a new one, but ...
1
vote
1answer
1k views

move a database to a different drive on the same server? [closed]

I'm trying to figure out how to point the database of my existing Sharepoint foundation install to the D: on my server. It was installed on the C: We just upgraded the D: to hold a lot more and need ...
0
votes
2answers
87 views

MOSS2007 active DBs

Whats the best way to tell which dbs are being used in your farm? Having moved and changed db servers over time, i now have dbs everywhere, wanting to do a clean up?
1
vote
3answers
5k views

How do I reduce the size of the config log file?

Our Small Business Server 2008 installation has recently run out of drive space on the C drive. While working to free up space I noticed that SharePoint_Config__log.LDF is 4.4GB. The associated ...
0
votes
1answer
168 views

Database size differs between Sharepoint and SQL

We have configured RBS in our sharepoint 2010 environment, when we calculate the database size from sharepoint its shows 90GB however the database size in SQL server is around 25GB and RBS size is ...
3
votes
5answers
12k views

List of databases used for a sharepoint 2010 farm?

How to find the list of databases are used by a SharePoint 2010 Farm, including content databases, service application databases and configuration database.
0
votes
1answer
617 views

SharePoint Farm SQL Server tempdb/Crawl DB disk configuration

We've identified I/O latency on SQL Server portion of our farm. We see tempdb and CrawlDB are biggest offenders. We have 2 extra Raid 1 disks available to us. Let's call them X: and Z:. The ...
2
votes
1answer
238 views

MOSS 2007 to Sharepoint 2010 migration

Steps followed for Migration: Backup up of production database Create New Web Application on SP 2010 farm. Restore Production Database on SP 2010 Farm. Create Solution in SP 2010 with Name Space ...
0
votes
2answers
168 views

Powershell (or sts command) for moving SC databases

I have 5 sc in 1 database (Database1). (Databases have been created for each sc). Now the task is to move 4 of the sc database from Database1 and put them into different database (where they belong). ...
1
vote
1answer
2k views

moss 2007 content db migration to sharepoint 2010

I am in a middle of content database migration of MOSS 2007 built on SQLServer 2005 to SharePoint 2010 with SQLServer 2008 R2. This is what I've done. Installed SP 2010 Standard Edition ...
0
votes
1answer
144 views

Completely empty content database

Anyone come across the following issue? WSS3 installation using WID, the content database for the site was empty. All of the tables were there but each table was empty, AllUserData, Sites, etc. Allll ...
1
vote
1answer
600 views

Move SharePoint 2003 Portal Server database to SQL server on different domain forests

We have an old installation of SharePoint 2003, with a basic setup:- Server 1: SharePoint Portal Server Web Applications on Windows Server 2003. Server 2: SQL Server 2008 hosting config and content ...
0
votes
2answers
618 views

fill a dropdown with data from a list using client object model

how can i fill a sharepoint 2010 dropdown with data from a list using client object model? i am trying to create an aspx workflow association form and want the initiator to choose an option from an ...
11
votes
3answers
363 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
2answers
414 views

Two seperate Sharepoint Servers pointing to the same Content Database

Is it possible to have two seperate sharepoint web servers pointing to a single content database on a seperate server? I do not want to do this concurrently. If I switch one web server off, then ...
2
votes
1answer
770 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
149 views

Connecting Web part to external Database

I'm trying to connect a web-part running in Sharepoint 2007 site to an external Sql Server 2005 database. I get a System.Secutity.SecurityException with "Request Failed" message when I attach debugger ...
6
votes
1answer
91 views

Which database will feature stapling affect?

We are testing feature stapling and need to revert to a point before the feature stapling was run. To do this do we just need to restore the content database, or do we also need to restore the ...
0
votes
1answer
435 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 ...
5
votes
3answers
2k views

Sharepoint 2007 farm performance goes down?

Our sharepoint 2007 farm is not working properly and we are facing a huge performance hit, some times it throws an unexpected error too. What all are the points to check? i.e like Depth of the ...
0
votes
1answer
327 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 ...
2
votes
3answers
2k views

How do I clean up missing server side dependencies from a “dirty” installation?

After a rather hasty (unavoidable) migration/reconfiguration of a SP 2010 Foundation box, I am left with an error in CA regarding a number of missing Features, SetupFiles, and WebParts. I redeployed ...
0
votes
1answer
69 views

FBA in hosted SharePoint

Does anyone have details on how to create Forms based Authentication using SharePoint 2010? I have a scenario where i want users to login and view information relating to them from a database. This ...
0
votes
1answer
596 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
170 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 ...
1
vote
3answers
315 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 ...
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
2answers
233 views

SharePoint 2007 Web-application is getting crashed due to memory leak

We decided to duplicate an existing web-application (for Podcasting kit), which has site collection only at root level, so created a new web-application (in the same DB instance) and imported (stsadm ...
1
vote
1answer
335 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 ...
1
vote
3answers
2k views

How to Enumerate ALL SharePoint MOSS databases

I want to enumerate all databases used by my SharePoint 2007 system. The stsadm -o enumcontentdbs only handles content db's but I also want the names of the SSP, Search and any other databases used by ...
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 ...
1
vote
2answers
10k views

database size would exceed your licensed limit of 4096 MB per database

We are using sharepoint server 2007 and if i create any files and folders the sharepoint site is throwing some error "Exception from HRESULT: 0x80040E14" and i checked event viewer.here also some ...
3
votes
2answers
153 views

What is a safe way to reconnect a server from another farm to the network?

I have VMWare image clone of our virtual Sharepoint web frontend. All the connections are the same (same farm basically), same exchange server, same sql server. I am afraid to connect this box to the ...
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
1k 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
1k 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
621 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
3k 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
298 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
54 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
256 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
454 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
193 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
443 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 ...