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

0
votes
3answers
2k 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 ...
0
votes
0answers
11 views

our sharepoint content database is on “upgrading” status after running my product configuration wizard [duplicate]

Last week our system admin install some patches on our SharePoint 2013 server. and seems one of the updates MS16-004 caused problems with our list view. and i read that installing this hot fix "KB ...
0
votes
2answers
10 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
23 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 ...
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: ...
0
votes
0answers
16 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
13 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
15 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
43 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
71 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 ...
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 ...
1
vote
1answer
78 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
46 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
2k 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
33 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
100 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
26 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
29 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
32 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
15k 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
886 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
14 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
29 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
24 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
26 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
71 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
36 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
50 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
260 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
23 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 ...
0
votes
0answers
81 views

Move content database SharePoint 2010 404 error

I get a 404 page not found error after I run a mount-spcontentdatabase command. I have Production SharePoint 2010 farm with application server, Front end and application server installed on windows ...
2
votes
1answer
99 views

Why is the New-SPContentDatabase command looking for .mdf file in E:?

I am trying to create a site collection with its dedicated content database in SharePoint 2010. To that end, I am trying to use powershell with New-SPContentDatabase command. Here is the command I ...
0
votes
0answers
147 views

PS1 Script Clone user permission , Exception on You cannot call a method on a null-valued expression

This script clones Users permissions given a Source user and a target User. It works perfectly in my test environment but not in production. #Function to copy user permissions Function ...
0
votes
1answer
27 views

What is the difference between Data Migration and Data Archiving

What is the difference between Data Migration and Data Archiving? We have a Sharepoint application for document archiving, and its database size is nearly 1 TB. So I have a plan to reduce the size of ...
0
votes
0answers
31 views

SharePoint 2010 performance blocking issue at particular time

After some changes, deployed this week, SharePoint 2010 can't operate properly, throwing Timeout error for any action. It appears at a particular time - 9pm. All actions, which affect database fail ...
2
votes
1answer
5k views

Local farm is not accessible, cmdlets with featuredependencyid are not registered

So after moving all my databases to the new SQL server I run this on my SharePoint central admin box, http://technet.microsoft.com/en-us/library/cc512725(v=office.15).aspx#Man Everything goes through ...
0
votes
1answer
15 views

Changing the drive of a database

Ok so I have a database server. I went to create a new test site so created a web app and a site collection which obv created a content database. I then did a restore onto that site collection from ...
4
votes
4answers
9k views

Claim SQL server space after content deleted from SharePoint

We have a site collection with its own database where we have been testing migration of a department's shared drive content (about 40GB) via a third party tool. The test migrations went fine. Before ...
0
votes
1answer
36 views

Migration Sharepoint foundation 2010 to 2013 issue on mount db content

I'm face an issue. I've a sharepoint 2010 Foundation and installed a sharepoint Foundation 2013. I've created a web app on SP 2013 and restored the wss_content from SP 2010 on my server for 2013. ...
0
votes
0answers
23 views

Database Attach, all content missing

I am doing a database attach upgrade from 2007 -> 2010 -> 2013 I exported all the site collections and theyre all fine except for one. After running the following commands the new site collection is ...
0
votes
1answer
40 views

Unable to access sites during a SharePoint DR test

Our company does not have hot DR site for our SharePoint environment. So we are using the process to restore the data to our DR site: Create all site collections in DR pointing to the same ...
2
votes
2answers
230 views

Microsoft.SharePoint.Publishing.InvalidPageLayoutException after moving site collection

I have two web application: http://old.corp.com http://new.corp.com I had a site collection on http://old.corp.com/path/1. The site collection was in a dedicated content database and is based on a ...
0
votes
1answer
123 views

Content database “Version” in table != (get-spfarm).buildversion

How is this possible? The Content database with the version 15.0.4719 was generated with this server, of version 4569. I only noticed it because I tried taking a backup and mounting it to another ...
0
votes
0answers
49 views

The webpage cannot be found after creating new site collection

I created a new content database and then created a site collection. When I try and access that newly created site collection, I get 'The webpage cannot be found' page. I am able to create new site ...
0
votes
1answer
77 views

How InfoPath data is stored in database?

How InfoPath data is stored in database? Is it XML or some other format? Can I import excel data to an existing InfoPath web template?
3
votes
3answers
138 views

How much space in the DB will be saved by using RBS?

We are doing a migration from SP 2010 to 2013. We are going site by site (moving content databases to a new server). Some of the content databases are over 200GB, from what I can see mainly due to ...
0
votes
1answer
51 views

SharePoint 2010 content DB attach

I am attaching a content db from moss 2007 SP version to SharePoint enterprise 2010 edition as part of refer for the overall objective. but the content db is occupying the complete space. is there any ...
1
vote
2answers
28 views

Can upload content when content database is offline

When we set content database as OFFLINE in CA, can user still upload content like documents, lists etc.? Because the description in CA says setting OFFLINE means no new site will be created but it ...