A usually large collection of data organized especially for rapid search and retrieval (as by a computer).
0
votes
0answers
180 views
Updating MOSS list with MS Access- Object is read-only
I have a user who needs to update a large (39,000 items) MOSS list from MS Access 2007. The list is a simple one, created by publishing a query from Access to MOSS, now needs to be updated weekly. The ...
2
votes
1answer
86 views
Storage Location of Installed Features
Are features installed on a site stored in any of the databases?
I know the assemblies installed to the GAC from a .wsp are not, however are the features themselves stored in a database?
9
votes
3answers
2k views
How to split a Content Database within site
I have a very large content database & need to split it.
Is it possible to split a content database within a site collection? or I need to create a new site collection?
0
votes
2answers
168 views
Does anyone know which database table Job Titles are stored in on WSS 3.0?
I need to edit the job titles of users in an installation of WSS 3.0. There doesn't seem to be an easy way of doing this as an administrator. Users can edit their own details via the ...
1
vote
2answers
192 views
Need to access a database…what is the best/proper/recommended way
Here is the setup. I have a SQL Server database that i need to query. I want to display the information in a Telerik/Devexpress chart control on either an application or site page.
Here is what i ...
1
vote
1answer
97 views
SP2010: Is modifying of admin content DB stored procedure permissionssions allowed?
I'm having a problem in production environment with help pages. Basically the problem is that the application pool account for some reason does not have permissions to run the required stored ...
0
votes
1answer
155 views
Sharepoint 2010 - database reconfiguration after failure
We had major database crash and our master database got broken. Probably it will be rebuild so then we will have to configure logins and user mappings for sharepoint databases. Is there some kind of ...
3
votes
3answers
2k views
Enormous database log files - Why are they not being truncated after a SharePoint backup runs?
I've performed a full Farm backup and also a full Site Collection backup using Central Administration site but there are still several enormous database log files
4GB - SharePoint_AdminContent
53GB ...
-1
votes
2answers
508 views
Using linq to get aggregated total of distinct values from csv items in datatable
I am going to use linq to get datapoints for chart created in sharepoint from datatable
this is datatable with 2 columns "task" and "users"
task users
task 1 john
task 2 mike, ...
0
votes
1answer
45 views
Renaming SP2010 Service Application DBs
Does anyone have any experience of renaming the SP2010 Service Application Databases. They were created and I don't recall an option to manually name them (as you can with Content DBs). They are in ...
4
votes
2answers
7k views
Central Administration cannot connect to configuration database
I made a script for batch uploading files, which I successfully used to upload more than 900 files (few gigs of data). Today I prepared another set of files and everything was working fine, but ...
0
votes
0answers
204 views
Linq Data Context - connect from web part as application pool identity
I have an assembly with linq to sql mappings and I'd like to utilize it in my webpart. But when I try following:
DataList dataList = new DataList();
dataList.DataSource = DB.Foo;
...
0
votes
1answer
138 views
Attach restored content DB to same web application
I have an issue with a customer DB with it being corrupted. This has been the case for a while and hence no way to revert to a backup because all the backups have the corruption as well. I am however ...
2
votes
2answers
94 views
Get default db instance
I'm writing web service which will be part of my sharepoint solution. This service will save and read some data from custom db which will reside on the same mssql instance as sharepoint. I'd like my ...
0
votes
1answer
41 views
Additional databse - best practices
Our system needs to synchronize data with external systems by web services. We want additional database to keep needed data and then be able to access it. I wonder how to resolve issue with database ...
1
vote
2answers
365 views
Update a list via SQL with MOSS2007?
How can I go about applying an update statement to a on MOSS2007 deployment?
Essentially I'd like to write something similar to the following across it:
update <list_name>
set ...
2
votes
1answer
2k views
How to know the GUID of a Database?
I follow this step by step http://technet.microsoft.com/en-us/library/ff681014.aspx for reset the User Profile Synchronization Service but I need the GUID of the synchronization database. I searched a ...
1
vote
2answers
872 views
Database Attache Upgrade Fail?
I ran the mount-spcontentdatabase and it failed. The test-SPContent Database didn't produce anything in the log that would fail the upgrade. Also, the error report didn't have anything that would ...
5
votes
1answer
349 views
How to corrupt content database?
I am working on a solution using which Site Admins can check and repair corrupt DB. I need sample corrupt DB for testing. Any ideas how to corrupt content database?
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
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 ...
5
votes
2answers
589 views
The Search Service Application crawl DB default has grown to 60GB
Our Search Service Application was installed but never configured with rules. Our default Search Service Application Crawl DB has grown to 60GB. We attempted to create a new Crawl Database and ...
2
votes
2answers
864 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 ...
5
votes
2answers
186 views
How to move SQL user database to SharePoint?
I have a SQL and a Access database which I need to import to SharePoint. These database contains information collected from my Internet site like registration info, usernames etc.
Is this possible ...
0
votes
2answers
1k views
How should I set up my database instances for multiple SP2010 installs?
I'm setting up three SharePoint instances. We have a single database instance (DB\SP2010) that will hold all the databases for these three SP instances. Will this be overly confusing? Is there some ...
1
vote
2answers
114 views
What are the implications of using a shared/default SQL Server instance vs a dedicated/named one for SP2010 DB Role?
I have a database server that hosts multiple minor databases not related to SharePoint and I want to utilize this server for a SP2010 environment database role.
What are the implications of ...
1
vote
2answers
1k views
Sample/Demo Database for SharePoint 2010
I'm looking for a sample/demo database for SharePoint 2010 in order to be able to demo SharePoint. Does anyone know of such a thing? Ideally it should have already created and populated lists and ...
0
votes
1answer
132 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 ...
0
votes
1answer
153 views
SilverLight webpart reading data from a external server through sharepoint
Let's hope i'll be clear enough. Ok.
I have a request to create a silverlight webpart, that'll be 'fed' with data that comes from a third server. This external server can't (security issues) be ...
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 ...
0
votes
2answers
1k views
Is it possible to migrate and attach a wss 3.0 configuration database to a new Foundation 2010 front-end?
We are preparing to migrate from WSS 3.0 to 2010. WSS is currently on a x86 operating system, so migrating to a x64 operating system will be involved as well. My co-worker's thought is to turn up a ...
0
votes
2answers
169 views
SharePoint 2010 Install test.. changing mind on service accounts and undoing Wizard created services/dbs?
We have a new 2010 Environment. Ran through quick on our install.. with the likely intention of having to do it again anyways. To keep thing simple, only have two service accounts. The farm admin ...
2
votes
1answer
200 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 ...
1
vote
2answers
64 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
246 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 ...
5
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 ...
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
77 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?
0
votes
1answer
65 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 ...
11
votes
3answers
278 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 ...
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 ...
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 ...
0
votes
1answer
145 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 ...
1
vote
1answer
428 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
1answer
135 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 ...
0
votes
1answer
480 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 ...
1
vote
2answers
379 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 ...
0
votes
2answers
147 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). ...
