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
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 ...
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 ...
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
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
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
53 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
52 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 ...
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
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 ...
1
vote
2answers
90 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
52 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 ...
0
votes
2answers
84 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
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
199 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
129 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
21 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
56 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
136 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
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 ...
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 ...
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 ...
4
votes
1answer
271 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 ...
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 ...
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 ...
1
vote
1answer
41 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 ...
-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?...
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
2answers
41 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
59 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 ...
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.
10
votes
1answer
396 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
44 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
132 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
175 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:...