A Content Database is an SQL Server database where the content of a SharePoint intranet (extranet, public web) is stored.

learn more… | top users | synonyms

1
vote
3answers
4k views

How to identify Orphaned Site Collection in SharePoint 2013 Content Database

We have recently discovered following error in SharePoint Health Analyzer report page: "Content databases contain orphaned items." We have identified the faulty content DB, database status of content ...
2
votes
2answers
1k views

Host Named Site Collections with own Content DB, and problems (Top Nav Bar, and force to log on always)

This is the scenario: All Site Collections have their own Content Database Site Collection A is Root Site Collection (created directly under Web Application = has exact same url as Web Application ...
0
votes
1answer
637 views

What data is stored in the Sharepoint 2010 content database?

What is stored in the content database. It it only list & library data or absolutely everything. e.g. site collection info, sub sites, pages, images, libraries, web parts, schemas etc. Thanks
0
votes
0answers
9 views

Strange content behaviour after site restore

I restored with restore-spsite a site collection into a new farm. The content db passed from 10.7GB to 4.7GB. When I download some content document - browsing locally - it may download suddenly, or ...
2
votes
1answer
22 views

content db size issue

I migrated two site collections sequentially using a 3rd party tool from SP 2010 to SP 2013. The fist site collection was almost 200 plus gb on source and became 80 GB on destination (thanks to ...
8
votes
1answer
1k views

The UPDATE permission was denied on the object 'AllListsAux', database 'spContent', schema 'dbo'

Insufficient SQL database permissions for user 'Name: NT AUTHORITY\IUSR SID: S-1-5-17 ImpersonationLevel: Impersonation' in database 'spContent' on SQL Server instance '###' The UPDATE ...
5
votes
1answer
5k views

“No connectivity with the server” for files in only one content DB?

SharePoint 2010 / SQL Server 2008 R2 One of my users reported a problem opening files yesterday. Upon opening a file she would receive this string of error messages: Clicking "Retry Open" leads to: ...
3
votes
2answers
86 views

Site Collection size cause

We have a site collection that has couple of document libraries each having 10K documents. And the content DB assigned to that site collection is showing 280 GB used. But when we check the library ...
0
votes
0answers
19 views

WSS 3.0 Restore and Add

I created a server to mimic our current production server of WSS 3.0. I was able to restore the database to the SQL server, and did the below command with an elevated command line. stsadm -o ...
0
votes
0answers
29 views

After SharePoint site restore not update the content DB

I got the SharePoint 2013 site collection back and solution wsp and restore them in new environment. It is done. But when I go to the sharepoint list and update the list with front end custom web art ...
0
votes
2answers
25 views

Programmatically Create Site Collection within a Specific Content DB or move to a specific Content DB using SP Object Model & Not PowerShell

Is it possible to specify the Content DB to which a site collection will belong while creating a Site Collection? I am using the SelfServiceCreateSite API. If not, is there a way to move a site ...
0
votes
1answer
14 views

Sharepoint 2010 Database version

We have an weird error we cannot find out why this happened. We have some content database that are showing : SharePoint database is in compatibility range and upgrade is recommended But the what is ...
1
vote
0answers
31 views

Extract Workflow column value from AllUserData table

I have a SP 2010 content database and I am trying to extract list data from it. I cannot successfully restore the content database to a SP farm, that's why I am trying to directly retrieve the data ...
1
vote
1answer
52 views

MOSS 2007 + ContentDB size ~500GB = Performance Issues

Have an old MOSS2007 "mammonth" on SQL 2008, which have performance issues. IIS often crashes and gives "Unknown error". It is a two-tier Farm with Database on one server and WFE+App.Server on the ...
1
vote
2answers
34 views

SharePoint 2013 moving data to another server

I have SharePoint 2013 Enterprise version. It is installed from last 3 years. Topology as below SQL01 (Clustered) SQL02 (Clustered) FE01 (load balance) FE02 (load balance) APP01 APP02 Now I got ...
0
votes
0answers
54 views

“An error was encountered while retrieving the user profile” in sharepoint Log DB

We have 70 thousands+ user profiles in our user profile service application. when i search some profile in manage user profile page, i can easily find the profile without any errors. But when i see ...
1
vote
2answers
26 views

Query Sharepoint databases in production

what are the important reasons to not query sharepoint production databases , if we want to run even select sql queries is any issue to database? in a case if i want to do select query and want to ...
0
votes
0answers
53 views

404 FILE NOT FOUND: After Restoring Content DB

I have taken backup of content DB of one web application from production database server and restored to my development database server. content DB restored successfully. Content DBs have exactly same ...
0
votes
2answers
87 views

Sharepoint Multi-Tenancy with separate database per tenant

I currently have 1 customer setup with multi-tenancy using a site subscription with a set of features. The assumption at the time was that i would share a content database with other tenants. The ...
1
vote
1answer
59 views

Emptying recycle bin doesn't make more free space available

I've copied a 10 GB site to a site collection in another content database. Then I deleted the site and emptied the recycle bin of the former site collection. The database size has remained the same ...
11
votes
5answers
15k views

Restore-SPSite to the same content database

I ran Restore-SPSite on my server from a backup. I then deleted the site collection and did it again but got the following error: Restore-SPSite : The operation that you are attempting to perform ...
1
vote
2answers
91 views

How to change database server for sharepoint farm?

I have a SharePoint farm with multiple content DBS, but I will shutdown database server because we need to use a different one. I realized the people who installed this didn't use SQL alias. I know ...
0
votes
0answers
53 views

Error retrieving a list from unattached content database

I'm trying to retrieve a library from an unattached content database. Unfortunately after selecting the site collection and library I get the following error: [2/23/2016 5:00:31 PM] Start Time: 2/...
0
votes
1answer
20 views

Attach a content Database

I'm trying to attach a content Database and I managed with the following command: PS C:\temp> Mount-SPContentDatabase "Wss_ContentBack" -DatabaseServer "MYSQLSERVER\INSTANCE" -WebApplication http:/...
0
votes
1answer
29 views

Getting content from Unattached Content Database Data Recovery

I'm trying to get some content from restored sql server SharePoint db So in Central Admin I choose; Unattached Content Database Data Recovery I feel in my database name and sql server instance and ...
1
vote
1answer
100 views

Restore a Content Database from spbr0000 using Powershell

I have took a backup of our live content database using the following command:- Backup-SPFarm -Directory \\servername\f -BackupMethod Full -Item WSS_Content_ea05******15e8 -Verbose which ...
2
votes
2answers
62 views

unable to backup our sharepoint content database “Backup Database is terminating abnormally”

I want to backup our live Content Database, now i went to "Central aministration>>Backup>>perform backup",, but i could it find our content database. so i try running the following command on the ...
0
votes
2answers
202 views

Are there any risks of running (Get-SPContentDatabase <content database name>.Repair($false) on live database

I am working on SharePoint server 2013 enterprise , and i run the Health Analyzer, but i got this error "Content databases contain orphans items" :- Here is the full description of the problem when ...
1
vote
2answers
46 views

Conflict Content Databases names inside my sharepoint farm

I am using SharePoint server 2013, and i am facing problems on understanding how to manage my SharePoint content databases:- currently i have a single content database, with name = ...
1
vote
1answer
131 views

Remove Orphans site collections inside my content database raised the following:- Exception calling “Repair” with “1” argument(s)

I run the product configuration wizard on my SharePoint server 2013, after a hot fix installation:- psconfig.exe -cmd upgrade -inplace b2b -wait -force but i received the following exceptions, ...
0
votes
2answers
22 views

Restore 1 site collection from a content database that contains several other site collections

for testing purposes I need to restore a site collection form our Live environment to our test farm environment. I have done this a few times where a site collection has its own database, but in this ...
0
votes
0answers
57 views

Unable to open document from Drop off library in SharePoint 2010

Unable to view documents from drop of library it showing error message When I open pdf documents from a web application, I found below error in uls logs System.Runtime.InteropServices....
0
votes
0answers
19 views

Content Server goes error constantly

Here is the case: on SharePoint 2010 a content database is attached. But, it constantly gives error. Every time I have to click on it and press OK, and it changes to Started status. But it gets back ...
1
vote
0answers
19 views

Multiple content databases and Multiple search agents

So I have one big database which is over 1 TB now, and also this is my content database which is connected to SharePoint 2010. Although full and incremental crawl go well and search works(also i am ...
2
votes
0answers
23 views

Sharepoint to WordPress migration - Public Site

What are my options for export content of public site from SharePoint db into usable form for WordPress? I found some tools, but i would rather hear expirienced advice from someone who already done ...
0
votes
2answers
84 views

Best practise for upgrade site collection with its separate content database in sharepoint 2013?

In Sharepoint 2010 farm web application : http://www.company1.com ;content db : wss_company site collection : http://www.company1.com/products ( /Products is a explicit managed path in company1....
2
votes
1answer
137 views

Procedure to restore site collection from a sql db of a different farm

I need to restore a site collection from a SQL DB of a different farm. This SQL DB holds only a single site collection. Both (destination and source) farms are identical except that they are in ...
1
vote
1answer
120 views

SharePoint 2010 Content DB rapidly increasing in Size

SharePoint Health Analyzer rule detected the unused free space in WSS_Content Database, so to free up the space I had to shrink the Database. Before shrinking, the size of content DB was 259 GB. After ...
1
vote
2answers
80 views

Deleting a corrupted Site Collection

I have a site collection which is corrupted, it was not deleted correctly and now I cannot fully remove it. It does not appear in the Central Admin, but it does with Powershell. Compatibility level ...
0
votes
3answers
5k views

How can I know in which content database my site collection is stored?

I have a farm and I see in sql many content databases. I have some site collection and would like to find something in the userinfo table in the sql database. But in which content database do I need ...
1
vote
0answers
37 views

Options for moving large amount of documents to library

I am working on migrating documents from our RDBMS (Oracle) to a given SharePoint 2013 library (1 site collection, 1 content database). The total size of the documents to be migrated is over 400GB ...
4
votes
1answer
272 views

How to manage audit log table size in Sharepoint 2010?

As I know the Audit Log Trimming timer job is responsible for trimming the audit logs, but in my case Audit Log Trimming timer job stuck on pausing state after 5% progress. If I restart the SharePoint ...
1
vote
1answer
34 views

How can I control a content database size in sharepoint 2013

My case is I have one web application which has only one site collection, for example, http://examplesite . This site collection has a content database, for example, wss_content. Then I created a new ...
1
vote
0answers
51 views

New-SPContentDatabase : String or binary data would be truncated

When creating new database manually in PowerShell using command New-SPContentDatabase -Name $ContentDatabase -WebApplication $WebApplicationName it works fine, but recently it has started to fail ...
1
vote
1answer
34 views

Upload data stored in external SQL database

I want to upload some data which is stored in external SQL database to SharePoint database and it should reflect in forms under SharePoint.
8
votes
6answers
17k views

Content database shows no site collections

I accidentally removed one of the content databases from a web application. I mounted it back but now the content database shows zero site collections in it. I really messed up the production system, ...
0
votes
2answers
1k views

Move-SPSite vs Copy-SPSite

In my environment I need to perform a Move-SPSite and a Copy-SPSite. Why do Move-SPSite need a IISreset and Copy-SPSite do not? Can I just use a Copy-SPSite (and delete one db) to avoid IISReset?
0
votes
0answers
18 views

How to retrieve all the links within all SharePoint 2010 Pages with a specific domaine

Basically what I'm trying to do is retrieve all the urls with specific domain within the all SharePoint pages. Is there a simple way of doing it ? I tried to retrieve the list from the database ...
1
vote
2answers
42 views

Get error after content database restore to another server

I have some problem with restore sharepoint content database. get back up content data base from server A. then restore to SQL server server B. create a new web application in server B. add restored ...
0
votes
0answers
47 views

“Object reference not set to an instance of an object. ” when creating site collection

When I try to create a site collection, I get the error Object reference not set to an instance of an object. I've done some digging, and have found an answer here. However, I followed the steps, and ...