A usually large collection of data organized especially for rapid search and retrieval (as by a computer).
1
vote
3answers
295 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
1k 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
219 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
314 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
777 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
7k 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
145 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
43 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
2answers
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
573 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 ...
0
votes
5answers
2k 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
281 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
246 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
433 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
184 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
434 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
1k 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
66 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
108 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
1k 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
589 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
865 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
84 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
306 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
454 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. ...
