Questions tagged [content-database]

A Content Database is an SQL Server database where the content of a SharePoint intranet (extranet, public web) is stored.

Filter by
Sorted by
Tagged with
25
votes
2answers
2k views

Contacts Web Database site in SharePoint Server

I created a site of type Contacts Web Database under a team site collection in order to maintain some contacts. As soon as I created the Contacts Web Database site on the homepage under the 'Address ...
15
votes
5answers
22k 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 ...
14
votes
6answers
33k 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, ...
12
votes
1answer
2k 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 ...
11
votes
2answers
4k views

SharePoint 2010 RBS and the 200GB content database limit

So "SharePoint Server 2010 capacity management: Software boundaries and limits" says about the 200GB limit: If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage and ...
10
votes
9answers
18k views

Content database size vs site collection size

We have one rather large content database in our environment. In this content database, a single site collection resides. In Central Admin, this site collection lists as being 464699 MB big. Since ...
10
votes
2answers
2k views

size of content database does not decrease after deleting content

I am using SharePoint Foundation server in my development environment, it has a content database with size almost 68 GB. I deleted all the major content (media file and documents) but its size does ...
10
votes
3answers
9k views

Content DB Split - Sub-site into Site collection is the only way? And How?

Our sharepoint database is large ~180GB. I want to split it up into smaller database from the disaster recovery point of view & also that it can be easily moved across servers. The problem is that ...
9
votes
1answer
7k views

Splitting a Content Database into two or three?

I have a SharePoint Farm in which the main Portal Web Application uses a single WSS_Content database, which has grown a lot to about 150 GB. I know I can now put it offline and attach a new one, but ...
8
votes
1answer
21k views

Placing a Sharepoint OpenBinaryStream() into a byte array Csom

I am able to traverse through my entire Picture Lib, however when I am trying to place into a byte array I am getting an it shows that the value of the OpenBinaryStream(); is empty. My is to go ...
8
votes
2answers
2k views

The best practice for moving content database between two farms

I have two farms both running SharePoint 2010 and SQL Server 2008 R2, basically something like a development environment and a production environment. I have a site running on web app - port 80 and it ...
8
votes
1answer
2k 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 ...
7
votes
1answer
6k 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: ...
6
votes
2answers
9k views

Deleting an orphaned content database

I had accidentally deleted a content database "CDB-A"(not important) without doing a detach. I also added a new content database "CDB-B" to the web application. SP 2010 seems to hang on to "CDB-A" ...
5
votes
4answers
29k views

List of databases used for a sharepoint 2010 farm?

How to find the list of databases are used by a SharePoint 2010 Farm, including content databases, service application databases and configuration database.
5
votes
4answers
819 views

SharePoint Content DB exceed 200 GB

As per Microsoft site I saw content DB size will be 200 GB for best performance. I want to know if site collection size reached 200 GB then as an admin, what action should I take to reduce the size so ...
5
votes
4answers
16k 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 ...
5
votes
1answer
184 views

Create a Replica of Content DB and use it as content database of new web application in the same SPFarm

Am having a Single Server Farm Environment wherein I am having 1 WFE and 1 SQL Server machine . in the SQL server box, I have taken a backup of SharePoint's web application's content DB. Content DB ...
5
votes
1answer
3k 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 ...
5
votes
1answer
2k views

How to remove "orphaned" users from a site collection?

We recently performed a domain migration where we migrated several forests and domains into a single domain. From speaking to the AD admins, this was done using a tool from Quest and it maintained SID ...
5
votes
3answers
2k views

Host Named Site Collections with own Content DB, and problems (Top Nav Bar, and force to log on always)

This is the scenario: All Site Collections have their own Content Database Site Collection A is Root Site Collection (created directly under Web Application = has exact same url as Web Application ...
4
votes
4answers
236 views

SharePoint 2013 too many content databases

I joined a company where there are 10 content databases created for 10 site collections(SP2013 version). All the databases together has less than 80GB content. Well I don't know why they created ...
4
votes
1answer
367 views

Is Content Database Encryption Supported?

There are some folks in IT that are interested in Encrypting all of the SharePoint Databases, specifically the Content Databases. Is this a wise option and is it supported? We will be using SP2016 ...
4
votes
1answer
13k 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 ...
4
votes
3answers
1k 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 ...
4
votes
2answers
186 views

Single Site Collection growing above 200 GB limit

What is the recommended approach when a single site collection (on a Content Database) is growing above the 200 GB limit? All files are stored in the same site collection, within different sites and ...
4
votes
1answer
381 views

Sharepoint 2010 site stopped working. Database “needs upgrading”. Upgrade fails

One of my Sharepoint 2010 Site Collections has stopped functioning this morning and presents the following in the browser. Server error: http://go.microsoft.com/fwlink?LinkID=177673 When I look at ...
4
votes
1answer
758 views

What is diffrence between SPContentDatabaseSequence and SPContentDatabaseSequence2

When i am inside Mange Content Database settings page inside my farm, i see 3 different Schema Version for my content db as follows: I understand the first listing that is Microsoft.SharePoint....
4
votes
1answer
53 views

Are SharePoint sitepages related to performance problems?

SharePoint stores customized site pages in the content database. So, suppose there are 1000's of pages which are created and modified by users (say by adding webpart), some are created and modified ...
4
votes
1answer
3k views

Upgrade Required SharePoint_Config

When I go to "Manage Servers in Farm" from Central Admin, I see a red alert that says "Upgrade Required" against web front end. When I run the stsadm command stsadm.exe -o localupgradestatus , I ...
4
votes
1answer
212 views

Does writing a custom RBS provider force one to put SharePoint into unsupported state?

It is well known that modifying a content database directly by running direct SQL queries results in an unsupported SharePoint state. However, it is possible to develop custom RBS providers. Note that ...
4
votes
1answer
982 views

Can't restore backup of content database using stsadm after migration to SQL 2008 R2

WSS 3.0 on Server 2003 within a Domain. I set the server up 3.5 years ago along with a test setup. It's the first and only SharePoint install. I recently had to migrate the content database from ...
4
votes
0answers
599 views

Move multiple site collections from one content database to multiple content databases

Is there a easy way to divide site collection equally between the number of content databases attached to a single web application? I'm having a single content databases where a lot of sites were ...
3
votes
4answers
30k 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 ...
3
votes
2answers
848 views

Need to get content database in SharePoint online using CSOM

I need to access a content database's name, and its properties like Size, etc. using CSOM in SharePoint online. Is there a possibility?
3
votes
2answers
24k views

SharePoint configuration and content databases

Can 2 servers in SharePoint farm have their own SQL server database? Or they must share database? because when I was installing second server in farm it said that servers must share config database. ...
3
votes
3answers
11k views

How to delete an unused content db in SharePoint

Error: Databases required upgrade or not supported : The following databases require upgrade because their versions are older than the backwards compatible range: ...
3
votes
3answers
1k views

Where do you deploy scripts that are loaded in a masterpage?

Do you deploy the script files to "_layouts" or the content database? If "_layouts," do you use a <ScriptLink> tag or a <script> tag?
3
votes
1answer
338 views

Is accessing SharePoint content Database in code advisable?

I want to know if it is a correct thing to access SharePoint content database in code i.e (using custom SQL queries)? If not can anyone provide me with an explanation why shouldn't it be done?
3
votes
5answers
2k views

Why can't I create site collections in some CDBs?

I currently have my SharePoint 2010 server set up with twelve content databases. In each is or should be one site collection at the moment, but as I went through to set up each one five of them gave ...
3
votes
3answers
1k views

Is it possible to migrate a ContentDB between farms with different build

I am wondering if it is possible to migrate a Content Database(using Mount-SPDatabase) from a source farm which has 2013 but an older build version, to a destination farm which also has 2013 but a ...
3
votes
2answers
197 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 ...
3
votes
3answers
3k 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 ...
3
votes
2answers
143 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 ...
3
votes
1answer
2k 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.
3
votes
1answer
172 views

How to check whether Content Database is read-only or not?

How to check whether Content Database is read-only or not using client context ? we can easily get using server object model but how to do this with Client Object Model
3
votes
1answer
4k views

Office web apps does not have access to content database

I have issues with Office Web apps. After some logging search I found it's because of the service account of owa service application does not have access to the content DB. I've read somewhere that ...
3
votes
1answer
85 views

What negative impact can occur if I detach a Sharepoint content database file location via SQL?

The end goal is to move the MDF file of a non-critical Sharepoint site collection to a different drive. The database server/name/etc... is going to be unchanged. Microsoft basically states that the ...
3
votes
2answers
39 views

How does SharePoint Designer interact with core?

When an user does some changes like changing background color or adding an image for Home.aspx via SharePoint Designer what actually happens at this moment? In other words what happens under the hood? ...
3
votes
1answer
958 views

How to recreate a view by xml?

I can retrieve the xml data of a view which is stored in the [WSS_Content].[dbo].[AllWebParts] table. example of decompressed content of a view: <root> <ViewFields> <FieldRef ...

1
2 3 4 5
8