Hot answers tagged content-database
8
This is a known issue[citation needed] and unfortunately restoring to a new content database is the only workaround (I refuse to call it a solution since you now have a new problem). Once restored, you can't move the site back either; the error it returns is about how the site used to exist in the content database.
If you can, avoid deleting site ...
7
When I need to move content from one environment to another I use backup/restore. I see no reason in copying the files, it's far easier to use the backup/restore routines - also there are often the case that you use other tools than SQL backup to do the actual backup.
Copying the files is also a dangerous option due to file locks etc, and you don't want to ...
7
There is an information worker download of a complete environment from Microsoft. This includes a pre-populated sample AD, documents, lists, libraries, profiles, etc. http://blogs.msdn.com/b/cjohnson/archive/2011/09/15/2010-information-worker-demonstration-and-evaluation-virtual-machine-sp1.aspx
6
To do this we exported each site to the local file system, created a new site collection with the new content DB and them imported the site into the site collection.
You can export a site using PowerShell and Export-SPWeb.
I recommend testing this process too before you execute it in production, we had lots of tidying up to do with customisations etc.
...
6
In SharePoint 2010 you can add additional Content Databases to your Web Application and then use the Move-SPSite PowerShell command to move site collections from one database to the other.
To add a Content Database: Goto Central Admin > Application Management > Manage Content Databases. Select your web application and add a database.
To use the ...
6
I would take a look at these two links:
http://ktskumar.wordpress.com/2009/03/10/sharepoint-databases/
http://grounding.co.za/blogs/neil/archive/2008/08/16/sql-databases-used-in-sharepoint.aspx
They go over the various databases that SharePoint has under the hood and what their purposes are.
That being said... I would recommend staying away from ...
5
Everything is stored in database tables. You have one or more content databases setup for each application. Each Content Database contains the content for one ore more site collections. This includes lists, documents, version, workflow content, permissions, site information, etc.
The configuration information is stored in the Configuration Database, and ...
5
Short answer, the quote above does say RBS and the content database must not exceed the limit. Not just the content DB when RBS is used.
Database size is such a gray area with SharePoint. MS's recommendation of 200GB is to ease the maintenance of the database.
"Content databases exceeding 200 GB and up to 4 TB support much of the
same flexibility as ...
5
First thing you should do is choose the appropriate recovery model for your databases.
If you need point in time restore, go for the FULL recovery model. The price you have to pay is to make regular log backups or your logfile will grow indefinitely. Taking a full backup does not stop them from growing. If you use mirroring or log shipping, you also need to ...
4
This has been discussed before recently.
Assetlib has its advantages (it gets cached so i wouldnt worry alot about performance) with versioning and can be used for cloud and multitenancy (as it is not stored on the disk). LAYOUT doesnt suffer from incorrect max-age, so a single roundtrip is saved here.
As always with SharePoint, the answer is, that it ...
4
Here are some details about support for large databases with SP1. http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=988
Officially there is support up to 4TBs with optimization, but realistically that is difficult to support and should only be used in extreme exceptions. Technically there were no real changes made to support the additional ...
4
Whatever ID the application pool is running as needs 1) proper permissions to the config database (see this info from Microsoft) 2) inclusion in the proper security groups on the local machine (these usually start with WSS_) and 3) permission to go through the proxy using a windows credential rather than a forms-style login. If you are in a large corporate ...
4
You should be backing up and truncating your TLOGS. If you have not been doing that, than yes, do a backup, truncate, and shrink will restore space. To keep that space however, you will need to set growth limits on your database and log files. Microsoft has a paper on "best practices" with SQL maintenance:
...
3
I have been through the same scenario as you described (also with the Quest tool). We cleaned it up by running the stsadm -o migrateuser command. This will migrate all of the content associated with the old account to the new account and remove any references of the old account in the site collection. It needs to be run once per user, per farm.
3
You might be able to get a bit more information about the events that lead up to the error by checking the log files in
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS
ULS Viewer is a utility that can be used to view, sort, filter etc the log entries based on, for example the correlation id that you are given by the erorr ...
3
PowerShell is just a wrapper for the object model. You shouldn't need to reference PowerShell in your feature, just create the new site collection with C# inside your feature. There's a blog post here that illustrates some code that may get you started. http://blog.mastykarz.nl/programmatically-creating-sites-site-collections-custom-web-template/
3
One of the first steps to any upgrade is to perform the Test-SPContentDatabase check against every content database in the farm. If this check finds errors, your upgrade will not complete successfully. There's no way around this; if you want a successful upgrade, you must pass both the stsadm preupgradecheck and Test-SPContentDatabase.
If the errors are ...
3
If you want to know databases in your farm instance, use Get-SPDatabase as suggested by another answer.
If you want to understand what databases sharepoint creates and what exactly sharepoint stores in them, check Databases That Support SharePoint 2010 Products
3
Place your script files under
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\CUSTOMAPPNAME\JS
And add the script tag
<script type="text/javascript" language="javascript" src="/_layouts/CUSTOMAPPNAME/JS/script.js"></script>
Please don't put the script files in the content database. In other other ...
3
The easiest way I have found is to use the SPWebApplication.GrantAccessToProcessIdentity method. It sets up the database permissions for you. It will alter all of the content databases in the web application for you, the downside is, when you add a new content database, you need to call this function to setup the permissions again.
You can do this with the ...
3
Try to disable the firewalls for both the database server and the sharepoint front end temporarily and try again. Make sure the account you are logged onto and running the SharePoint Config Wizard has proper database access.
Also, Are you bindings in IIS Manager linked to the old IP or hostname? Change that and try again.
Also view my blog about this:
...
3
IMO, you should definitely use RBS because majority of files are larger than 1MB. In your case, your DB can further grow exceptionally large because of all the binary large object (BLOB) data. And, Reading and writing BLOBs, as well as other relational data, can slow down SQL Server performance because it’s not the ideal place for storing BLOBs. By using RBS ...
3
SharePoint 2010 Service Pack 1 does support content databases up to 4TB, if upgrading to Service Pack 1 is one of the things available in your SharePoint road map, let's do it to utilize maximum its capability.
I've found a white paper "Managing Multi-Terabyte Content Databases with SharePoint 2010" written by MCM, Sr. Technical Product Manager Bill Baer. ...
3
The farm you received the database from is most likely at a different patch level than the farm you are trying to mount it to. Get the systems to the same patch level and then try mounting the database again.
Also, you will most likely want to remove the root site collection from your development environment because if you are trying to restore a root site ...
3
It depends!
SharePoint can easily handle that amount of data and that amount of files. But there is no "magic recipie" that you just apply to SharePoint and then upload all that data. You need to think of how these documents are going to be used (read/write scenarios), you should organize them in Site Collections and sites (and with that split out ...
3
The short answer is you don't.
Directly interacting with a SharePoint content database will cause your SharePoint installation to lose Microsoft support.
This applies even to just using SELECT statements without changing any data.
Any interactions with SharePoint should be performed via the object model.
2
Yes, that is correct - you can't attach two copies of the same content database in the farm because the various GUIDs will be the same. Unfortunately the error messages you get when you do this are not especially helpful.
The workaround for this is to create a temporary farm somewhere and attach the database there - then back it up from that farm. This ...
2
Did you run Test-SPContentDataBase after restoring backups? This will tell you if you are missing anything that might affect site operations. Additionally after starting the upgrade process the logs will tell you if any sites were skipped. If you leave any installed in MOSS when you backup, you will need to install those features before attaching DB in ...
2
Don't be fooled by the "have sufficient free space" message...I think that's just part of a higher level generic error message.
I had this same exact error about a month ago and the only way I was able to get around it was going into Central Admin, create a new content database on the web app, and then use the databasename argument on the Restore-SPSite ...
2
When you delete a Site Collection, it will still remain in the Content database until the "Gradual Site Delete" Timer job is run (by default, it runs once daily). So, once you delete the site collection and run the timer job, then you can again restore the same site collection in the same content database.
Only top voted, non community-wiki answers of a minimum length are eligible
