Tag: database
Unable to add new SQL feature from original media after installing SP1
Problem The SQL Database server was updated to SP1 before PowerPivot was installed using the original (pre-SP1) media. This resulted in the installer failing saying that the version of sqlncli.msi (SQL Server 2008 R2 Native Client) on the installer was not correct. Solution Download Service Pack 1 for SQL Server 2008 R2 if you haven’t […]
Continue Reading...Configuring Remote Blob Storage on SharePoint 2010
Since recently upgrading to SQL Server 2008 R2, we decided to do some testing with the new feature called Remote Blog Storage. This new feature allows files to be stored locally on disk if it exceeds a specified size, thereby reducing the size of SharePoint content databases. There are several resources on the net that […]
Continue Reading...SharePoint Database Maintenance
Microsoft has released a database maintenance guide for administrators. Its worth a read and easy to follow. Only a few pages long, it details a step by step process on creating a SharePoint SQL Maintenance Plan. Download it here.
Continue Reading...Migrate sites using database attach method
Requirement Recently had to reinstall SharePoint for our developer. He had a content database with a bunch of site collections in it and he wanted to keep it after the farm was reinstalled. Solution After reinstalling SharePoint: Re-attach the database in SQL Management Studio. Mount the content database in powershell and attach it to the […]
Continue Reading...The transaction log for database ‘WSS_Content’ is full.
Problem We have WSS 3.0 running on Windows Server 2008 R2 internal database. One of our users recently received an error when trying to give another user permissions. The error message was ‘Exception from HRESULT: 0x80040E14 which didn’t mean anything. Checking the ULS logs, the following error message is displayed. Unexpected query execution failure, error code […]
Continue Reading...