Category Archives: SQL Server 2008 R2

SQL Server 2008 R2: Move Database Files to a New Location

I am in the process of decommissioning an old server. This server performed several roles, but was primarily our SQL Server. In moving a couple of the databases, they did not end up exactly where I wanted due to the … Continue reading

Posted in SQL Server 2008 R2 | Tagged , | Leave a comment

SharePoint 2010: Move a Site Collection to a Different Content Database

I had recently ran into a case where a site collection was not created in the correct content database. Moving it to the correct database is very simple. SOLUTION 1) Open the SharePoint 2010 Management Shell as the SharePoint Farm … Continue reading

Posted in SharePoint 2010, SQL Server 2008 R2 | Tagged , , , | Leave a comment

SharePoint: Database Maintenance

There are two maintenance tasks that should be performed routinely to ensure SharePoint is running at its best A) Database Backup Maintenance Plan B) Integrity and Reorganization Maintenance Plan In addition to these Maintenance Plans, you should also see my … Continue reading

Posted in SharePoint 2010, SQL Server 2008 R2 | Tagged , , , | 2 Comments

SharePoint: SharePoint_Config_Log is Large

I was looking at my backup logs and noticed how long it was taking to backup our SQL Server that is hosting our SharePoint databases. ┬áConsidering that we are just now adding content to it, it should not be taking … Continue reading

Posted in SharePoint 2010, SQL Server 2008 R2 | Tagged , , , | 1 Comment

SQL Server: Configuring Remote Blob Storage for SharePoint

SQL Server databases can store and query a vast amount of information kept in the raw with little effort. But once we introduce SharePoint into the mix, those Content Databases can grow exponentially fast and under perform because we may … Continue reading

Posted in SharePoint 2010, SQL Server 2008 R2 | Tagged , , , , , | 1 Comment