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
0answers
16 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 ...
4
votes
1answer
4k 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: ...
1
vote
1answer
41 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 ...
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 permission was ...
1
vote
2answers
27 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 ...
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: I. All Site Collections have thier own Content Database II. Site Collection A is Root Site Collection (created directly under Web Application = has exact same url as Web ...
0
votes
0answers
17 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
3answers
3k 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 ...
1
vote
2answers
24 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
26 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
57 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
47 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
70 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
46 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: ...
0
votes
1answer
18 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 ...
0
votes
1answer
20 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
84 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
51 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
129 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
43 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
94 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
19 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
45 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 ...
0
votes
0answers
18 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
20 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
70 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 ...
2
votes
1answer
108 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
102 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
68 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
4k 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
35 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
168 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
28 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
38 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
16k 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
16 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
39 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
31 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 ...
1
vote
1answer
36 views

personalize this page - DB location

I am currently using the "personalize this page" feature for a web part page. I've had users make changes to their personal page although I can't locate this information in the content database. ...
3
votes
2answers
75 views

Programmatically create a ContentDatabase C# SP2013

I am searching for a solution of my problem. I banged my head for the last few hours and tried several things and solutions found on google or stack-exchange. The database should be created via Event ...
0
votes
2answers
2k views

Orphan Site Reported After Running Test-SPContentDatabase

I'm upgrading from 2010 to 2013 and when I ran the Test-SPContentDatabase (on destination WFE server pointing at original content DB) command I got the following error relating to an orphan site: ...
-1
votes
2answers
38 views

How to know that “EnableVersioning” is enabled in any SharePoint 2013 List/Library using SQL Query

I want to know if below proprieties are enabled or disabled for any SharePoint 2013 List/Library. How we can get using SQL Query from ContentDB (AllLists Table), which column I have to use in my ...
0
votes
2answers
38 views

Content DB size of a restored webapplication is huge

I have restored a Sitecollection(Export-SPsite) which was migrated from SP2010 to SP2013. This new site's (without any content) actual size is 900MB (Got it from SharePoint designer), However the ...
0
votes
1answer
57 views

Accessing an Intranet database in SharePoint and make it available on internet

Is it possible with SharePoint to access an Intranet DataBase and get all the data from it and make it available on the Internet online? The context: Right now we have an application that ...
10
votes
1answer
341 views

why i should not perform a Restore-SPSite for a copy of a site collection on the same content database

I have read these links which talks about using Backup-SPsite && Restore-SPSite:- link1 link2 and they both mentioned that restoring a copy of a site collection's back-up file file using ...
1
vote
1answer
33 views

Any possible problems when migrating SharePoint 2007 databases from SQL 2005 to 2012

Due to SQL Server 2005 EOL, we plan to migrate all SharePoint 2007 and 2010 content databases to SQL Server 2012 (or SQL 2008). I wonder if it will be safe to migrate, and any possible points to be ...