0
votes
2answers
29 views

Sharepoint 2010 and 2013 on same SQL Server

We have a Sharepoint 2013 installed with SQL database Cluster and our old Sharepoint 2010 databases should also be moved to the new SQL database Cluster but not migrated to Sharepoint 2013. I have ...
0
votes
2answers
50 views

confused about database attach upgrade from 2010 to 2013

I am in the process of a test upgrade from 2010 to 2013. I have set up a new test farm and I want to start attaching databases to the test farm but I have a few questions I can't figure out. What ...
2
votes
1answer
32 views

Is reading from SP Databases supported through Open Specifications?

Microsoft has documented certain things as part of their Open Specification. This includes SharePoint, like MS-UPSSDSP (PDF) which is documented as Specifies the User Profile Social Data Stored ...
1
vote
1answer
103 views

Does 'Web Access Database Sharepoint site' created in Sharepoint 2013 sync/work with Microsoft Access 2010

Will I face any compatibility issues when I use MA 2010?
0
votes
1answer
71 views

SharePoint DB Server - CPU usage 1 to 5%. RAM is almost 100% at all the time [closed]

On the SQL server box. I bumped the RAM to 24 GB and allocated 20GB for SQL Server. Now the performance looks like attached print shot. I see there is barely 1 GB RAM available and only 31 Free. Is ...
3
votes
1answer
62 views

Are documents in SP2010 saved directly to MS SQL Database

When I Upload a document e.g. Word or Excel documents to a document list. Are the files saved directly binary to an SQL database? If yes, could someone give me a url by MS, where I can find further ...
0
votes
1answer
994 views

Sharepoint site stopped working. Database “needs upgrading”. Upgrade fails

One of my Sharepoint 2010 Site Collections has stopped functioning this morning and presents the following in the browser. Server error: http://go.microsoft.com/fwlink?LinkID=177673 When I look ...
7
votes
3answers
2k views

“SharePoint is not a database!” article of 2009 - does it still apply for SP 2010 and 2013?

I'm talking about this blog post by Chris Woodill. He mentions the following advantages of modeling data via SQL programming instead of SharePoint's lists: Primary And foreign keys: one of the most ...
0
votes
0answers
286 views

Database Attach Upgrade - Warnings and Errors

After running the database attach upgrade and getting the site collection running. SharePoint is advising about some problems. 1- Databases running in compatibility range, upgrade recommended. The ...
2
votes
1answer
133 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?
2
votes
3answers
5k views

Move databases to another server

I have tried moving all databases to another server, but I forgot to change the default database server in Central Administration. From Googling it, I found out that stsadm or psconfig could help me ...
0
votes
0answers
433 views

How to change the database server in SharePoint server 2010?

I have SharePoint Server 2010 installed on Server A (all the roles are on the same machine),and now I need to add a new server B which must be the new database server, so I need to move all the ...
1
vote
1answer
121 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 ...
1
vote
1answer
3k views

WSS_Logging database size

Our sharepoint server 2010 WSS_Logging database is about 100GB and counting ... (Farm DB ~1TB / ~100 000 pages viewed per day / ~5000 unique users per days) I've reduced retention and logging ...
3
votes
3answers
4k 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 ...
5
votes
1answer
448 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
3answers
281 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 ...
11
votes
3answers
4k 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
2k 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
4answers
437 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. ...
7
votes
1answer
3k 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 ...