A Content Database is an SQL Server database where the content of a SharePoint intranet (extranet, public web) is stored.
8
votes
2answers
650 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 ...
7
votes
3answers
5k 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 ...
6
votes
2answers
956 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 ...
5
votes
3answers
3k 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 ...
5
votes
1answer
2k 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 ...
4
votes
1answer
431 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 ...
4
votes
2answers
3k 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" ...
3
votes
4answers
2k 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 ...
3
votes
1answer
167 views
Remote BLOB Storage and Sharepoint 2010
I have a SharePoint Server 2010 documents library. Library's size - 20 Gb. Size increases each year by 1-2 GB. It stores files ranging in size from 1 to 50 MB. Files rarely change.
Should I use the ...
3
votes
1answer
43 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 ...
3
votes
4answers
3k 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, ...
3
votes
1answer
61 views
Architecting a department site with 2 TB+ of data
We are looking at the possibility of migrating 2TB+ worth of data from our network driving into SharePoint for a department site. For this question I'm assuming all data is valid and has the ability ...
3
votes
1answer
86 views
Checking if the content database is in read-only using javascript?
Hi I'm pretty new to SharePoint and javascript. I am trying to check if the content database is read-only, and if it is then preform a function
eg.
if ...
3
votes
1answer
366 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 ...
2
votes
7answers
2k views
Failed to detect if this server is joined to a server farm
Hi As I said in one of my previous question,
I have got a virtual Machine Image (VMWARE) for MS server 2003 with MOSS 2007 setup. Where they changed both IP and host name.
Following problems I face ...
2
votes
2answers
454 views
Should I regularly backup and shrink my content databases through SQL?
I've been contending with hard disk space on my SharePoint 2010 (with SQL 2008) environment for a while and I've just recently found out a few things that I think might help.
Should I be regularly ...
2
votes
3answers
518 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?
2
votes
2answers
1k views
Mount-SPContentDatabase error
I have recieved a copied database from a live farm and am trying to restore this database to my development environment. I have created a new web application and site collection and have restored the ...
2
votes
4answers
1k 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 ...
2
votes
1answer
994 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 ...
2
votes
2answers
1k views
Programmatically create a site collection in an existing, mounted content database
I'd like to create a site collection from a custom application page in central admin. The administrator needs the option to specify an existing, mounted content database to store the new site ...
2
votes
2answers
45 views
Web site looks different after content db addition to a different farm
I backed up a content db from our production MOSS 2007 farm and then I added to an existing web application to the recovery wss 3.0 farm. However after doing it, the root site from the new db's site ...
2
votes
2answers
521 views
Copying a Content Database to another Farm?
I have a Sharepoint Farm and I want a clone of it, under a different hostname (Preprod vs. prod).
We setup the Preprod farm from scratch, with new Web Applications. We then restored a backup of the ...
2
votes
3answers
458 views
Large content database
My client has been on MOSS 2007 for nearly 3 years. We're about to do an upgrade to 2010 on their system and found their content database to be around 350Gb in total. This to me seems a bit ...
2
votes
1answer
199 views
MOSS 2007 to Sharepoint 2010 migration
Steps followed for Migration:
Backup up of production database
Create New Web Application on SP 2010 farm.
Restore Production Database on SP 2010 Farm.
Create Solution in SP 2010 with Name Space ...
2
votes
2answers
33 views
Remove mysite links from migrated site collection sharepoint 2010
I have migrated a content database to a different server and attached it to a fresh web application. Now my issue is whenever it points to old site where users had created their own site. i don't want ...
2
votes
2answers
66 views
Cannot find pages that have instances of missing webpart
I am trying to fix some missing server side dependencies on an SP2010 farm and am having trouble with missing webparts.
There are two problems specifically.
1) Of the pages I can find (two pages ...
2
votes
2answers
1k views
How to Restore Same Site Backup in Same Content DB to create another site collection in the same web application?
I have a site backup and i want to create two site collection from that backup in one web application.when i try to restore second site collection on same web application it restrict me to do so.As ...
2
votes
1answer
58 views
SharePoint 2010 - moving databases to new server & RBS
Our SQL cluster has some issues and techs are now building another cluster where we will have to migrate our SharePoint 2010 farm. I found technet article describing process of moving SharePoint ...
2
votes
1answer
973 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:
...
2
votes
0answers
367 views
Create a new Central Administration Content Database
Currently the Content Database for my Central Administration site has exploded to over 50GB, and expands to over 100GB everynight (leaving 50GB of free space). After much investigating I have ...
2
votes
1answer
567 views
404 Error after Deleting Content Database (With no Site Collections)?
After detaching a database in SharePoint then subsequently deleting in SQL Server I have been getting 404 Errors at my root site collection default.aspx page, and a few other random site collections ...
1
vote
4answers
7k 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.
1
vote
2answers
1k views
Sample/Demo Database for SharePoint 2010
I'm looking for a sample/demo database for SharePoint 2010 in order to be able to demo SharePoint. Does anyone know of such a thing? Ideally it should have already created and populated lists and ...
1
vote
2answers
203 views
What is the Best Method to Store 100s of Thousands of Files in SharePoint 2010?
My question is:
What is the best method for storing thousands of files (or millions) in SharePoint?
Every file's size is about: 5 MB * 1000000 = 5 TB
I need the best method for that that does ...
1
vote
2answers
193 views
Record Center and Content Database Infrastructure
I've ask yesterday about Document Libraries limits and the only thing that we have certain is that Microsoft recommends Content Databases <= 200gb.
I'm facing a situation here where I'm setting ...
1
vote
1answer
764 views
How to design for large content databases?
Although single content databases of upto 200GB is possible in Sharepoint 2010, administering and managing such a db would be a nightmare. What would you suggest for options in a case where there is ...
1
vote
1answer
400 views
Upgrade from 2007 to 2010 error on custom web parts
We have several SharePoint 2007 farms with several site collections in certain databases. The desire is to be able to migrate these 2007 site collections to our new 2010 farm envirionment. The best ...
1
vote
4answers
3k views
The web application at [url] could not be found
Any ideas on the error below?
This happens when I try to search for content on my WSS 3.0 site.
ERROR
" The web application at [url] could not be found. Verify that you have typed the url ...
1
vote
2answers
57 views
SharePoint 2010 - To use content database or not to use
SP newbie here. I need to build a SharePoint 2010 application to track customer support cases. This will be the first time we've used SP, and I can set it up how I please.
The built-in template for ...
1
vote
2answers
406 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 ...
1
vote
2answers
217 views
Mysite fails after changed content database?
I have a test environment which has a different URL and a different database server than the production environment. I’ve taken a backup of the production content database of mysite and attached it to ...
1
vote
2answers
833 views
Restoring a Document Library's content from a backup?
I have a sharepoint server backup and a database backup of the SQL2008 server which holds the sharepoint database.
Some infopath forms were deleted from the document library and I would like to ...
1
vote
1answer
1k views
Mounting two similar content databases
I have two content databases: Cdb_A (in Server_A) and Cdb_B := Cdb_A + (a lot of content changes) in Server_B. Im trying to host both in the Server_A but on different webapps.
My Webapp_A is attached ...
1
vote
1answer
47 views
Content DB not getting any permissions on web application created through central admin
I tried to create a Web Application using Central Admin. It created web app without displaying any error, I can browse site too after creating site collection and that, but content db got no ...
1
vote
1answer
86 views
restoring content databases and retaining permissions
I have a production Sharepoint web app that contains several content databases serving a group of site collections. There are some critical files in a group of document libraries and lists, so ...
1
vote
1answer
908 views
Copy content database from production to development environment
I have a production SharePoint 2010 server with multiple site collections and sometimes I would like to copy the content from the site collections into my development environment so that I can test my ...
1
vote
1answer
224 views
Is it possible to run Content Deployment incrementally using code?
I am running some Content Deployment jobs using the code but the jobs are not run incrementally, instead they are run by exporting all the objects. Is it possible to run them incrementally using the ...
1
vote
1answer
123 views
How can I determine whether a content database is being used?
I noticed quite a few SharePoint content databases with random names (i.e. WSS_Content_30cb56f0b9eb430a8a2e3180604efd7b). I believe these were created by developers during deployment, and were never ...
1
vote
2answers
866 views
Database Attache Upgrade Fail?
I ran the mount-spcontentdatabase and it failed. The test-SPContent Database didn't produce anything in the log that would fail the upgrade. Also, the error report didn't have anything that would ...
