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

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
19 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
47 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
74 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
44 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
78 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
42 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 query?...
0
votes
2answers
45 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
61 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
432 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
53 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
196 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
59 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 ...
2
votes
1answer
6k 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
10k 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
56 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
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
413 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
398 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
300 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
72 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
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
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 -...
0
votes
1answer
389 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
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
2answers
230 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
604 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
539 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.
1
vote
2answers
3k views

Content Database Is Not Listing In SQL Management Studio

I have created a new SP web application and the content database name which I have given is WSS_Content_Test. Application created successfully(I checked out and found IIS Website and App pool is ...
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
303 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 ...
0
votes
2answers
1k views

New-SPContentDatabase creates database with guid instead of name

I am quite new to Sharepoint and I have a question that has been bugging me for a few days now. I have a powershell script that is setting up some site collections in a Sharepoint webapplication I ...
2
votes
1answer
87 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
573 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.
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 ...
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
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
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
2answers
112 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
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 ...
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
124 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 ...