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
1answer
35 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.
10
votes
1answer
435 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
54 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
142 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
197 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 run:...
0
votes
1answer
60 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
36 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 ...
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 ...
0
votes
1answer
46 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
415 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
402 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
59 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
102 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
301 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 ...
1
vote
2answers
47 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 ...
0
votes
1answer
73 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 ...
0
votes
0answers
68 views

Site Collection does not exist in database. Site collection will not be moved

I am trying to move the site collection http://<webapp>/dealers/1020 from content database WSS_Content_2 to WSS_Content_7 I run the command: Move-SPSite http://<webapp>/dealers/1020 -...
1
vote
1answer
105 views

SharePoint Upgrade from 2007 to 2013 via DB attach method

I am currently in the process of migrating a sharepoint site from 2007 to 2013 via a double hop database attach method. But i am attaching the content db to 2010 environment then it gives me the ...
0
votes
1answer
395 views

Which Database table stores the XML column mappings for Lists?

First off, I'd like to say that I understand the limitations and the risk of accessing a Sharepoint Database directly. I am not updating the SP Content, just simply querying the data in a SQL View for ...
1
vote
3answers
5k 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
2answers
231 views

What is the best way to CRUD data in SQL database into SharePoint?

In Sharepoint site, I have a list, it will display data from the table in SQL database. When user insert, update or delete item in this list, the SQL database will be changed too. The change is one ...
1
vote
2answers
610 views

Cannot Mount a Restored Content Db to new Web application

In the same Application server, I have Created new Web application and I'm trying to Mount the Restored Content Db of another WebApplication. But in the end of the process it returns me the ...
0
votes
1answer
540 views

Sharepoint 2013 Database Upgrade, Stuck at “In Progress”

Looking at the Upgrade progress, it has passed the first SPContentDatabaseSequence(130/130) then it's 30% Complete after about 2 hours. Then it starts on SPContentDatabaseSequence2, and currently at ...
0
votes
2answers
21 views

SP 2010 recovery

I accidentally uninstalled SharePoint 2010 from control panel (Stupid me). Luckily SQL SP database such as content db is available. How to reinstall or recover back ? Help much appreciated.
2
votes
1answer
114 views

Add a second content database to Sharepoint 2010 farm with existing Remote BLOB

We have a SharePoint 2010 farm with 2 web front-end servers and 1 sql server database. The database server this farm uses is typical single instance sql server where all the databases, including ...
0
votes
3answers
306 views

MissingFeature - Issue

I am trying to get rid of the health error: [MissingFeature] Database [WSS_ContentDB] has reference(s) to a missing feature: Id = [id] I followed this link Removing features from a content ...
2
votes
1answer
88 views

Conditions in which SP Content DB gets locked

Apart from Content Database backup, what are the other conditions in which a SharePoint Content Database may get automatically locked?
2
votes
1answer
575 views

Change web application's content database

Is it possible to configure my existing SharePoint 2010/2013 web application to point to a new/existing content database residing on another database server? If yes then how could I do it.
2
votes
1answer
325 views

Source content DB Size after moving site collections

I have one content DB (Source content DB) with 500+ site collections in it. Recently i have moved all site collections to 10 different content DBs (using Move-SPSite command) in order to improve ...
1
vote
1answer
48 views

MissingSetupFile issue - file does not exist

I am trying to get rid of the health error [MissingSetupFile]. I followed some guide to get (querying the contentDB) the Id of the file (and of the Site and Web). The issue is that the file does not ...
1
vote
1answer
177 views

Splitting one Content DB into 10 DBs in SP 2010

We have 650 site collections all in one Content DB with 800+ GB in size. Because of this huge size, performance goes down and we have decided to split the DB into 10 different content DBs with maximum ...
1
vote
2answers
101 views

why we need to use web.AllowUnsafeUpdates = true, we don't use these things with traditional ASP.Net Applications?

based on this post When & why I need to use web.AllowUnsafeUpdates = true "For reasons of security, by default, Microsoft SharePoint Foundation does not allow you to make posts from a Web ...
0
votes
1answer
162 views

What is “proc_StartUndirtyList” and who calls it?

Good day. We have a multi-server sharepoint 2010 farm (2 front-end, 1 application, 1 SQL). In this farm we deployed a web application with a content database size about 1.7 terabyte. We use RBS for ...
1
vote
2answers
126 views

Moving Site Collections between Content DBs

I have a very huge Content DB with over 500+ site collections. I want to split it into many databases that I can done using Powershell. I have two questions: Whats will happens to users working ...
0
votes
1answer
31 views

site collections visibility problem

I have a SharePoint 2010 site that I believe is using the included SQL version instead of the 2008 R2 that I had installed so my DB size limit appears to be 4gb. I have created a second content DB ...
0
votes
1answer
110 views

Copy-SPSite destination database size issue

I am using the Copy-SPSite command to copy a site collection to an other site collection (differente contentDB). The source contentDB is around 50GB, but during the copy the size of the target content ...
0
votes
1answer
112 views

Remove-SPWeb - content database

Does the command Remove-SPWeb remove the web also from the content DB? I have a site collection with 10 webs, the size is around 100GB, I wish to remove some webs and reduce the size of the content ...
0
votes
0answers
38 views

STSADM.EXE -o restore options

I'm moving some moss databases from one database server to a new one. I've been following the steps outlined in this technet On step 13. Restore an SSP to the new location. I'm coming across some ...
1
vote
1answer
377 views

Create new site collection in existing web application with different existing content DB

I have a SharePoint 2010 root level site collection SC1 in web application WEBAPP1. I want to create copy of that site collection in same web application WEBAPP1. Apart from Import/Export, Restore/...
0
votes
0answers
41 views

Sharepoint 2013 content DB restore issue

I'm trying to restore a content DB from a test server to prod. Followed the steps documented in the link : https://sergeluca.wordpress.com/2013/05/10/note-to-self-moving-a-sharepoint-contentdb-from-...
0
votes
1answer
679 views

Site Collection 403 forbidden

I created a new SP2013 Web application and I mounted two old content DB. Now I am getting error 403 while opening some sites from the browser. Sites were working fine, there are no locks and I am ...
1
vote
2answers
113 views

Site collection Access Denied

I get Access Denied while viewing asite collection from the browser. I am site collection administrator and I can open an other site collection in the same content DB I can do Get-SPSite from ...
0
votes
0answers
330 views

404 error when doing restore content database

Im trying to copy content database(one web application, exacly what I want) from our production- to our test-Environment. Im using this guidefor backing up (the CA-alternative). When I use the ...
0
votes
1answer
326 views

Missing server side dependencies error

Title Missing server side dependencies. Severity 1 - Error Category Configuration Explanation [MissingWebPart] WebPart class [3417184e-0312-0308-7a02-a4b2ce7fa8aa] is ...
2
votes
2answers
223 views

Access denied while creating content database from event receiver

I have created one timer job which will add SharePoint content database. When I am running timer job manually from central admin, Content database is being created successfully. Now I have one list ...
0
votes
2answers
267 views

Difference between ways to Copy Content Database from PROD to Dev Environment

I was looking for the best way to copy a SharePoint content database from PROD to Dev Environment, and found this (answered) question It seems ok, but there was another answer below the accepted one. ...
0
votes
1answer
205 views

Content Database(Size) when using RBS

When using RBS what is the total size limit that can be uploaded to SharePoint? Is there any size limitation concerning the data? When I right click on my content database that enable RBS it shows ...
-1
votes
1answer
64 views

site collection content db ldf file consumes huge space in C drive

I am having a site collection and it has dedicated content db. We have uploaded documents and now the size has become huge. when I checked the ldf file in sql server location am seeing the size is ...
0
votes
1answer
415 views

Powershell PS1 clone SP permissions Exception

I have found this nice PS1 that clone permissions from a SPUser To Other. When give inputs Many things goes wrong but I have non idea what. Has Anybody any idea about this issue? PS C:\Users\...
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?