Tagged Questions

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
1answer
18 views

How to store a lot of data for one application?

I have read that SP has a 200GB recommended max size for any content DB. I was also able to add multiple content databases to one web application. If my app needed to store BLOB data uploaded by a ...
0
votes
0answers
19 views

Missing Site collection when attaching a content database

We have a problem with a single site on our SharePoint and need to restore it from last weeks backups What I am trying to do, it to restore the content database from last week, attach this to a ...
0
votes
0answers
10 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 ...
0
votes
0answers
17 views

Access denied when using CreateUnattachedContentDatabase()

Im running c# code to creat SPContentDatabas but im getting Access denied each time im using this function CreateUnattachedContentDatabase(SQlConnectionStringBuilder) or ...
1
vote
1answer
16 views

How is DocumentSet Capture Version data stored in Content Database

Is it possible to know how a "DocumentSet Capture Version" data is stored in SQL Server Content Database ? (Not using OM but directly).
0
votes
1answer
28 views

When it is safe to delete entries from contentDB?

I have a file that is getting caught by the health analyzer ReportViewer.dwp as a missing setup file referenced [1] times in the database. I've tracked the file down to the web part gallery and ...
0
votes
1answer
20 views

Search Service App deleted, How to remove databases and stop services

I'm working on SharePoint 2013, configuring the Search Service. I created a Search Service Application through Powershell with some wrong setting and I tried to delete everything to start over again: ...
1
vote
2answers
14 views

Foundation Content Databases (2010)

How many content databases can be created with SharePoint Foundation 2010? I am having a hard time finding the answer. I think only one can be created but, I am not sure. EDIT: I did not think so. ...
1
vote
2answers
23 views

Roll back Sharepoint Products Configuration

I've performed a standard installation and run the Sharepoint Products Configuration Wizard. I've realized too late that the wizard wasn't asking me for info like Central Admin Content DB name, ...
0
votes
1answer
31 views

Must each content database in the farm have a unique name?

I'm wondering if a specific content database in the farm can always be identified by only its name? For example, if my farm consists of multiple SQL Server instances, must each content database in ...
1
vote
0answers
28 views

Sharepoint 2010 Adjusting lists limits to recomendations

I have huge list, which has too much fields of same type (e.g., Date and Time fields limit in list is 8, of that type I have way more). If those those limits are exceeded, list item data will be saved ...
1
vote
1answer
29 views

Export SharePoint 2010 SP2 site to SP1 SharePoint server

After patching our Test environment of SharePoint 2010 to Service Pack 2, Our project leader told me there is a website that need to go to production. Production is still in SP1. He planned with me to ...
0
votes
0answers
20 views

Content DB restore problem (SP2007)

I'm having an issue restoring a content database and hopefully one of you guys can help me out. I'm trying to replicate a live issue environment in a new temporary dev environment for troubleshooting ...
0
votes
2answers
47 views

How to promote a subsite to a new site collection with new content db?

We have subsites under our top-level site that are getting really big and I am trying to move them to their own site. I've created a new site collection and a contentDB. When I import the subsite ...
0
votes
0answers
20 views

How can I link infopath form's data to access database?

I have already created a form in info-path 2010 ( blank form template) and shared it on share point successfully now all I want is whenever a person fills out a form theses data automatically stored ...
0
votes
1answer
61 views

How-To Replicate/Migrate/Move SharePoint environment with new Naming & URLs?

Could you please help me out to accomplish the task below correctly and accurately? Scenario: I have a Test SharePoint 2013 environment that has a Web Application e.g. (http://Intranet.Corp.com/) ...
0
votes
0answers
16 views

Cannot create content database to use RBS with FILESTREAM in SharePoint 2013

When we tried to create content database to use RBS with FILESTREAM in sharepoint 2013 we configured according to the link we receive the following error as shown in the screenshot below . We did ...
1
vote
2answers
74 views

copy a SP 2010 site collection from prod to dev

We are trying to copy a SP 2010 site collection from our prod environment to dev. The site collection has it's own content db. Is it possible to just make a backup of the prod content db, restore it ...
0
votes
0answers
81 views

Content databases not automatically upgraded by Mount-SPContentdatabase

We have been told that a good process for accelerating the process of upgrading a farm (say installing a Service Pack) is: Detach all content databases. Install the Service Pack or Cumulative ...
0
votes
1answer
84 views

Sharepoint 2010 to 2013 upgrade problem

We ran into the problem when upgrading SharePoint portal with custom solution from 2010 to 2013 version using database attach procedure. Problem is that after mounting content database to SharePoint ...
1
vote
1answer
120 views

Database Update Status “ Needs Upgrade” Sp2013

I am in the process of upgrading sp2013 farm to SP1 upgrade soon. To prep for that i was going though datbase status page in central admin and saw the following: With that info on hand i was ...
1
vote
2answers
47 views

RBS Sharepoint 2013

I Enabled RBS on our SharePoint farm using the tech net article (http://technet.microsoft.com/en-us/library/ee748631(v=office.15).aspx) and i was able to successfully test the RBS for one content ...
1
vote
1answer
49 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 ...
1
vote
1answer
40 views

SharePoint 2010 Visual Upgrade Required Pre-SharePoint 2013 Upgrade?

When upgrading to SharePoint 2013, should the SharePoint 2010 content database have all site collections using the 2010 Visual Upgrade? We currently have a few sites that are still running on the 2007 ...
2
votes
0answers
164 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 was ...
4
votes
1answer
44 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 ...
0
votes
2answers
52 views

Use a single content database on two web applications

Can we use a single content database on two web applications in SharePoint 2007? I created a new application and a site collection. I want to use my old (existing) content database on the new web ...
1
vote
1answer
38 views

How do I restore a WSS3 Site with just the Content DB?

I am dealing with a system crash where I had a WSS3 site in a DMZ with a SQL2005 server remote (inside the Domain). The Web Server and the SQL server both were taken out is a system failure. I was ...
1
vote
2answers
21 views

Distribution of SiteCollections

I have the following scenario: 1 Content database 1 Webapplication with 28 Sitecollections The Size of this content database is about 100 GB. So I want to distribute newly created ...
0
votes
1answer
71 views

stuck on a database attach

I have a 2013 test box that I am working on trying to attach a content DB from our 2010 farm. I have mounted the WSS_Content database on the new server. I have made a web app and a site collection ...
0
votes
1answer
42 views

How are additional fields stored in a lookup column?

When creating a lookup column it is possible to select additional fields. Does SharePoint store the values of these additional fields in the "child" list, or is a database join performed every time a ...
4
votes
1answer
81 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 ...
0
votes
1answer
513 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
2answers
59 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 ...
0
votes
1answer
42 views

addcontentdb command missed something

So I have built a new sql 2012 server and SharePoint 2013 server. I have added the new SharePoint server to the farm and made it the default central admin site. I have moved all the content ...
0
votes
1answer
188 views

SharePoint content database DocStreams table very large

We recently migrated our SharePoint 2007 instance to 2013 using a migration tool. I noticed the disk space for 2013's database partition (300GB) on our SQL Server was running low. I ran a SQL report ...
0
votes
1answer
79 views

SharePoint Content Databases with PowerShell

Is there a way to get the current maximun number of site collections from a current database, and then be able to increase this by 1. I want to do this specifically in PowerShell for SharePoint. ...
0
votes
0answers
23 views

Two content databases for the one SharePoint application. Can I kill one?

I have an old SharePoint 2007 Sub-Site migrated across to my SharePoint 2010 environment via the DB Attach method. I've noticed that whoever did the DB attach has brought over 2 copies of the Database ...
1
vote
2answers
385 views

2010 Moving Content DB to new Domain - Problem with Users

I am restoring a content database to a new farm in a new domain. I have used the Move-SPUser command to map as many users over that exist in the new domain. I've used the delete orphan script to ...
0
votes
1answer
50 views

ContentDatabase exceeds storage limit

I have a SharePoint Site with only one existing contentdatabase. In this site are severa sitecollections. At the moment I am not far away that I reach the limit of 200GB for this database. My ...
3
votes
1answer
226 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?
0
votes
1answer
223 views

Documents / Library missing after migrating My Site to the new Content Database

I've moved some My Sites to new content database with the powershell cmdlet Move-SPSite. However, after moving them, it appears documents were "lost" on some of them (most of sites is just fine). When ...
1
vote
1answer
66 views

I want to know where are the timer jobs, webparts and user controls saved?

Are they saved in the content db or Layouts folder?
0
votes
1answer
127 views

Where are List View definitions stored?

Where can I find the raw definition within the Content database of a View on one of my Lists. I've found the list in AllLists and the View, I think, in AllDocs. But from there the trail is cold. I ...
0
votes
2answers
41 views

Pre installing solution doesn't solve the issue with the pre attach test

I want to attach a database to a newly created web application. I have a database which is correct. I execute the PowerShell script: Test-SPContentDatabase -Name ContentDB -WebApplication ...
0
votes
1answer
54 views

Does the entire web app or the entire site collection reside in a content db?

MSDN article paragraph: All sites in a site collection are stored together in the same SQL database. Keep extremely active sites in separate site collections. Because all content in a ...
0
votes
0answers
401 views

Error on Upgrade to sharepoint 2013

I'm trying to upgrade a webApp from 2007 to 2013. Following this tutorial: Tutorial The migration process to 2010 works perfectly . But When I try to do the same process to 2013, it breaks on 30% ...
1
vote
2answers
537 views

New-SPContentDatabase vs Mount-SPContentDatabase

We pre-create our SharePoint content databases in SQL, so we can distribute database files among disks and tune some parameters on the SQL Server side. Then we convert the SQL databases into ...
0
votes
1answer
51 views

Can I detach/move a DB by just stopping the site rather than fully shutting down IIS on the WS

On my SharePoint 2010 Farm and Web Server. I have a number of Different sites. Prod SharePoint, MySite, a separate ContentType Hub, and an attached DB of a 2007 Site. I want to move the Content DB of ...
0
votes
1answer
144 views

Single web application or mulitple?

I am very new compare to experts here. I have read several articles and discuss forums. However I am worry there are some potential risk I cannot foresee. Could you give me some suggestion on the wb ...